General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Access 2000 Report Sounds Easy??
Now counting the records is the problem!!! I can count the number of dates each name attended. But I need a Grand Total of the number of names listed. BUT EACH NAME SHOULD COUNT ONLY ONCE.
Example: The ***** is the part I am having trouble with.
Joe 08-01-2004
10-01-2004
Last Date Attended: 10-01-2004
Number of Meeting attended: 2
Sue 10-01-2004
Last Date Attended: 10-01-2004
Number of Meetings attended:1
---------------------------
Total Names Listed 2 ******
Any help you can offer would be greatly appreciated. I can send a sample db if you give me your Email address.
THANKS!
Alan