How do I summarize records in Access?

C

Cory

I have a table that has upwards of 70,000 records. I am wondering if there
is anyway that I can summarize this information so that it will contain less
records but so that I will still be able to see all of the detail.

For instance, I would like to create a table that would summarize data by
city (I am looking to summarize numeric information so calculations can be
done) so that I will still have all of my columns in tact but instead of 100
rows for each city, I will only have one.

Any help would be greatly appreciated!!
 
S

Scottgem

Hi Cory,

This is what queries and reports are for. For example you can create a
query and use a Group By query to summarize data by City. You can also
do this using the Report wizard and create a Summary only report. You
don't want to create tables for this since you would have to recrteate
them every time, but a query always pulls the current data.

HTH
Scott<>
Microsoft Access MVP 2007
 
Top