G'day,
I have an activity report which has multiple entries for the same date by club members. I have managed to build the database:
2 Tables
2 Queries
2 Forms
1 Report
Which list attendance's and activities by Member and Date and Prints each one starting on a fresh page......
What I wish to do is count each Club Members total days attendance.
I have tried using the Totals button but I don't know enough about expressions to get it to count multiple dates as 1.
Everywhere I have looked can tell me how to count between dates, around dates, workdays in a year etc. etc. etc. but none give me multiple dates the same counted as 1 :banghead: :banghead: :banghead:
There are a couple of other totals that I'll need help with but this is a start hopefully
Cheers
Lazy Dave
I have an activity report which has multiple entries for the same date by club members. I have managed to build the database:
2 Tables
2 Queries
2 Forms
1 Report
Which list attendance's and activities by Member and Date and Prints each one starting on a fresh page......
What I wish to do is count each Club Members total days attendance.
I have tried using the Totals button but I don't know enough about expressions to get it to count multiple dates as 1.
Everywhere I have looked can tell me how to count between dates, around dates, workdays in a year etc. etc. etc. but none give me multiple dates the same counted as 1 :banghead: :banghead: :banghead:
There are a couple of other totals that I'll need help with but this is a start hopefully
Cheers
Lazy Dave