Can I get the weighted average for the table?

  • Thread starter Thread starter Bryan
  • Start date Start date
B

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- 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
 
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
Click to expand...

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.
 
Back
Top