Web Development

Ask something
Discussion Locked

Access 2000 Report Sounds Easy??

0 helpful
7 replies

by mra2

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I 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: 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

7 replies

by whyong

if you want you can:
create a text box (Text1) in EmpName footer,
set controlsource "=1"
set running sum "over group"
set visible = "no"

and in your report footer,
Total Name Listed :
create a textbox (Text2) and set the controlsource "=[Text1]"

by mra2

The first Part (=1) works great. I left it as visible. But the form CAN'T find Text1???????

This discussion is closed to new replies.