How do you bin data in access?

T

Tim

Ok, lets see if i can explain this... I have a hunting harvest database
containing deer-by-deer data on date of harvest, age of deer harvested, sex,
and area of harvest. I want to calculate the average weight of deer
harvested within each weight class depending on the sex, year, and area of
harvest. How do I do this? And how can i set it up so that it is easy for
another user to do? I.e. click a button and repeat the analysis?

I think it is a matter of binning the data based on certain criteria, but I
don't know how to set up access to sort the data into year, area, sex, age,
then finally find the resulting average weight AND show the results all at
once- side by side.

Im very new to Access and while I know how to set up a simple database and
to create simple search querries, I don't know how to do this...

Thank you!
 
T

Tom van Stiphout

On Sun, 13 Dec 2009 09:35:01 -0800, Tim

Use a Totals query. Select Avg for the Weight column, and Group By for
the "bins".

-Tom.
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top