Totals in reports

[trying]

Hi, I'm just trying to do a simple report. I am taking 1 field from my table, and I just want to do subtotals. When I try to do it I get each record listed with a count next to it - I can't just have subtotals show up.

 

[ersocia]

1. this should have been posted in the Reports section of the forum

2. we need more information on what you're trying to do, in order to better help you. get a little more specific about exactly what you want.

 

[trying]

Sorry, I'm new to this and didn't realize how to post in the reports section - but will figure that out...
I have a table with 1000 records, 2 fields - the unique ID and type. I want a count of each different type.
So in the end I will get a summary report that would look like this:

Total Type
250 Brown Eggs
450 White Eggs
300 Jumbo Eggs

It's just literally a subtotal by Type. I can't get the report to just show me the summary of totals by type. It shows me all the details as well. When I went into design view and deleted the "details" - I couldn't get any of my data. It's so simple in excel, why I can't figure this out is so frustrating.

 

[ersocia]

ok, i think i get it.
search google for the phrase "add sums to your reports" and open the top result. should be an 'office.microsoft.com' link.

see if that helps out at all
(i'd paste the link myself, but i'm still under my 10-post limit for posting links/images/etc.)

 

[trying]

found it thank you.

 

[vbaInet]

You can do this in a query or report.

Query:
http://support.microsoft.com/kb/290136
http://office.microsoft.com/en-us/access-help/sum-data-by-using-a-query-HA010096310.aspx
http://office.microsoft.com/en-us/access-help/count-data-by-using-a-query-HA010096311.aspx

Report:
http://office.microsoft.com/en-us/access-help/summing-in-reports-HA001122444.aspx