access question

[zerocool1]

I was wondering how to do an average of several tables?

 

[archcommus]

Originally posted by: zerocool1
I was wondering how to do an average of several tables?

Average a column? Same column in multiple tables? In a query, report? Need more information.

 

[zerocool1]

Sorry, I want to average a column from multiple tables in a query.

 

[archcommus]

Can you just explain the scenario a bit more?

 

[zerocool1]

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.

 

[EagleKeeper]

Try to create a query to get all the data from the different tables.

From there you should be able to average the output.

 

[zerocool1]

I want to use the average function so I can just import the table, add the relationship and add the table into the query.

 

[archcommus]

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.

 

[zerocool1]

I understand that, I'm trying to build the function. I'm doing avg(month1, month2) essentially.

Amit

 

[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.

 

[zerocool1]

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.

Its telling me I have too many arguments

 

[zerocool1]

bump

 

[beggerking]

try [tablename]![column]

 

[zerocool1]

I'm trying to have it average several colums together.

 

[beggerking]

umm.. vba..

read each row /column

sum them up..

 

[zerocool1]

that's what I figured. Its been a while since I've touched vb so its gonna take a bit to reteach myself that stuff.

 

[Mark R]

Could you not use a union, then just avg() on one column? Use an appropriate group by clause, if necessary.

 

[zerocool1]

I should look into union. I might have to play with the syntax a bit. My sql isn't so good.