• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

access question

Ok, I've got several monthly reports from Oracle that I'm analzying. One field has name one, volume, one has dollar amount, one has the number of unique buyer. I'm trying to average the number of unique buyers over the course of several months.
 
Try to create a query to get all the data from the different tables.

From there you should be able to average the output.
 
I want to use the average function so I can just import the table, add the relationship and add the table into the query.
 
Like EK said, you can include ALL the tables in your one query. Then you can pretty much do whatever you want with the various fields.
 
Well, when you refer to the unique buyers column from each month, you'll have to prefix it with the name of the table, for example month1.unique_buyers, month2.unique_buyers, to specify which table and column you're talking about. I'd imagine you could just plop those right into the avg() function.
 
Originally posted by: archcommus
Well, when you refer to the unique buyers column from each month, you'll have to prefix it with the name of the table, for example month1.unique_buyers, month2.unique_buyers, to specify which table and column you're talking about. I'd imagine you could just plop those right into the avg() function.
Click to expand...

Its telling me I have too many arguments
 
Could you not use a union, then just avg() on one column? Use an appropriate group by clause, if necessary.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top