What Microsoft Access Formula Provides Summary?

Question

I have 80,000 product records in a Microsoft Access database. Some records may have the same name but a different location. How do I query and produce a summary on each name without any other information? For example:

ABC product is at 78216

ABC product is at 78216

ABC product is at 78216

ABC product is at 88273

ABC product is at 33333

XYZ product is at 78216

MNO product is at 78216

MNO product is at 78216

The query should show the following.

ABC

XYZ

MNO

Answer 1

You need to use the totals row.

Set it to Group By on the Names and then AVG, SUM, whatever you need on the totals, I believe.

If that's what you're asking.

If you just want to know how many unique names you have make a copy of the table, structure only, then index with no dups the name column, then append the old table to the new one and count the records.