Which dates occured on a Sunday?

[akhlaq768]

how can i write a query so it picks up all the dates that occured on a Sunday?

so i have a date field with over 300 records, i need to highlight which of those records (dates) are on a sunday

 

[maxmangion]

Hi,

search the forum for the weekday function.

Goodluck

 

[KenHigg]

You should be able to use the datepart() function to do this - Take a look at the MS Access help on it and post back if you need help using in it -

 

[KenHigg]

Or do what max suggests -

(You beat me to the punch )

 

[khawar]

SELECT YourTable.YourDate
FROM YourTable
WHERE (((Format([YourDate],"w"))=1));

Replace yourtable with your table name and
yourdate with your date field name

 

[akhlaq768]

thanks guys for the quick reply....

 

[maxmangion]

you're welcome