Query One Weekday

  • Thread starter Thread starter AishaM
  • Start date Start date
A

AishaM

I have tons of records with different numeric date fields in each. How can I
write a criteria (in Access 07) that will pull only the records that are
dated Sundays?

Thanks!
 
I have tons of records with different numeric date fields in each.
There are a whole lot of ways to use number to represent a date. I do not
know how yours are presented. So you will need to convert it to a date that
Access recognizes as a date.
Then use this --
Weekday( Your converted field ) = 1
 
Back
Top