How do I summarize records in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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
 

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

Similar Threads

Query to summarize/Count by month 3
VBA Help in Access 2007 1
How do I Total Summaries? 1
Report From Mulitple Child Tables 1
summarize data in access 2007 1
Summarize Data 4
Writing SQL code to delete duplicate records 0
Summarizing Data 1

Back
Top