Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Access 2000 Report Sounds Easy??

Locked

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

Topic

Reply To: Access 2000 Report Sounds Easy??

In reply to Access 2000 Report Sounds Easy??

What is the name of the field ‘Number ofMeeting attended’. Try =sum([ThatFieldName]).

Peter

Reply To: Access 2000 Report Sounds Easy??

In reply to Reply To: Access 2000 Report Sounds Easy??

Poster rated this answer.

Reply To: Access 2000 Report Sounds Easy??

In reply to Access 2000 Report Sounds Easy??

Try count(nameofperson)

Reply To: Access 2000 Report Sounds Easy??

In reply to Reply To: Access 2000 Report Sounds Easy??

Does NOT work

Reply To: Access 2000 Report Sounds Easy??

In reply to Access 2000 Report Sounds Easy??

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]”

Reply To: Access 2000 Report Sounds Easy??

In reply to Reply To: Access 2000 Report Sounds Easy??

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

Reply To: Access 2000 Report Sounds Easy??

In reply to Access 2000 Report Sounds Easy??

This question was closed by the author

[Author]

Replies