General discussion
-
Topic
-
Access 2000 Report Sounds Easy??
LockedI have a Parent Table with Names and a Child Table with Dates attended. The report shows the Name with the Dates attended in the Detail Section.I surpressed the repeat of the name. In the Group Footer, I have the last date attended which is simply the max of the date.
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: 2Sue 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