Time calculations

[Raul Sousa]

Can anyone help me here?
Can access calculate how many Mondays there are in period
of time? How?
I am using access 2003 Beta, and I am a new user, not
very skillful.

 

[Henry Smith]

Open the Access VBA Help File (available when you have the IDE on the
screen). Search for DateDiff Function. You should find your answer there.
In addition you could also look into DateAdd, DatePart, Day, Now, Weekday,
Year, and Format functions to give yourself a complete coverage of how
Access handles and manipulates dates and times.
Be patient and experiment with the DateDiff Function to achieve the count of
Mondays between two dates.

Cheers,
Henry