Query summarized & outputed to Excel?

[Kerman]

Is there a way to create a query that is summarized by 1 field, named "Cert
Number" and then exported to an excel file? I may have 1 to 35 records with
the same "Cert Number". I need all records with the same "Cert Number"
showing a grand total of data (Data is pounds) per "Cert
Number"...Thanks...Randy

 

[Jim Jawn]

Randy:

The easy way: (something I should have known a long time ago):

1.) In query designer, select your CertTable
2.) Add the "CertNumber" field, and "DataInPounds" Field
3.) Click on the "View" Toolbar, Select "Totals"
4.) Inside the query, a new row called "Total" wll show up.
5.) In the second "DataInPounds" field, select "Sum" from dropdown box
6.) Hit the Exclamation Point button. Should work.
7.) Right Click on the query (if it works) and select "export..."

That should work. Good Luck. Jim Jawn.