Reports

[Bill]

Hi,

I'm having a problem with reports that count ID numbers on the report. I am
going to give you an example.

I don't want the report look like this:
ID1 xxxxxxxxx
ID2 xxxxxxxxx
ID2 xxxxxxxxx
ID2 xxxxxxxxx
ID3 xxxxxxxxx
ID3 xxxxxxxxx
Total = 6 records
-------------------
I am looking for the report like this:
ID1 xxxxxxxxx
Total = 1
ID2 xxxxxxxxx
ID2 xxxxxxxxx
ID2 xxxxxxxxx
Total = 3
ID3 xxxxxxxxx
ID3 xxxxxxxxx
Total = 2

Your help would be much appreciated.
Thanks,
Bill

 

[Michael, Cheng [MST]]

Hi Bill,

From your description, I understand that you would like to have a total by
Group the countID. Have I understood the issue correctly and completely? If
there is anything I misunderstood, please feel free to let me know.

Based on my research and test, you could do follow these steps
(I use Access 2003 for test, but I think it will be OK if you use Access 97
/ 2000 / XP)
1. Create a new Report by Create report by using Wizard

2. Select the TableName you want to shown in the Report. Obviously, we
should include countID, num, etc. Then Click Next

3. Then you will see "Do you want to add any grouping levels?" Yes, We do.
Select CountID, click Next

4. Select the Accending, Layout, Style and Table Name, Clike Finish

5. You will see that it has been grouped by countID and you could get what
you want

Moreover, you could get detail information from Microsoft Office Access
Help about Groupheader and MSDN Online:
Group records in a report
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/htm
l/achowGroupRecordsReport.asp


Please feel free to post in the group if this solves your problem or if you
would like further help. We are here to be of assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.