[AccessD] weekdays and numbers

Hi Pedro

You could filter on: 

  Where Weekday([YourDateField], 2) In (1, 5)

and count records.

If you only wish to count distinct dates, you can create a Select Distinct query first and feed that to the query where you count.

/gustav



>>> pedro at plex.nl 14-08-2008 13:09 >>>
Hello Group,

i have a list of dates and i need to now how many dates are on friday or monday.
The dates kan be present more then ones (notation is: dd-mm-yyyy).

How can i calculate this?

Thanks

Pedro Janssen