Can I get the weighted average for the table?

[Bryan]

I have a table that lists crops, acres, and the average yield for each
production site. Some production sites are more acres than others. I would
like to get the average yield out of all sites, but is there a way to get it
so it is weighted based on the acres?

Thanks!

 

[Ken Snell \(MVP\)]

SELECT AVG(Field1*Field2) AS WeightedAvg
FROM TableName

 

[Bryan]

Ken- Is there any chance you could elaborate a bit on that? I am new to
access...

I tried looking around but couldn't see what you were referring to. Is it in
the design part of the query?

Thanks,
Bryan

 

[John W. Vinson]

Ken- Is there any chance you could elaborate a bit on that? I am new to
access...

I tried looking around but couldn't see what you were referring to. Is it in
the design part of the query?

Thanks,
Bryan

That is the entire query, in SQL view. Create a new query without selecting
any table; select View... SQL; and edit this in, using your own field and
table names.