Query by Week Beginning

Nav4

Registered User.
Local time
Today, 12:05
Joined
Aug 14, 2007
Messages
21
I am trying to generate a Query by week always beginning on a Monday. I pick any date....and want all records in both printed version and chart version i,e, number of safety meetings attended vs number who should have attended for this week. I can enter data with todays date, well any day this week. Then at some future date ask for who attended this week and percentages (another story). Any ideas?

Nav4
 
Access had a weekday function 1 for sunday 6 for saturday.
 

Users who are viewing this thread

Back
Top Bottom