query weekends

[ashaikh05]

Hello

I have a table which contains a date column dd/mm/yy.

How do I query the table so that only weekends (saturdays and sundays) are displayed and then i would like to create a report with that data.

Many thanks

 

[SgtJarrow]

something like:

SELECT Table5.mydate
FROM Table5
WHERE (((Weekday([mydate]))=1 Or (Weekday([mydate]))=7));

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[HarleyQuinn]

Something like:

WHERE (((Weekday([YourTable]![DateField]))=1 Or (Weekday([YourTable]![DateField]))=7));

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[HarleyQuinn]

Beat me to it!

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[ashaikh05]

Many thanks

 

[PHV]

And a shorter way:
WHERE Weekday([date field]) In (1, 7)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886