Web Development

General discussion

Gravatar
Locked

Access 2000 Report Sounds Easy??

By MRA2 ·
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

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

by p.verhagen14 In reply to Access 2000 Report Sound ...

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

Peter

gravatar
Collapse -

by MRA2 In reply to

Poster rated this answer.

gravatar
Collapse -

by john.a.wills In reply to Access 2000 Report Sound ...

Try count(nameofperson)

gravatar
Collapse -

by MRA2 In reply to
gravatar
Collapse -

by whyong In reply to Access 2000 Report Sound ...

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

gravatar
Collapse -

by MRA2 In reply to

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

gravatar
Collapse -

by MRA2 In reply to Access 2000 Report Sound ...

This question was closed by the author

Back to Web Development Forum
7 total posts (Page 1 of 1)  

Start or search

Related Discussions

Related Forums