How to exclude a time period from a query 1

[Taecca]

Need to create 2 queries:

Query 1 seems to be working ok:

Select * from temp
where WeekDay not in ("Sat", "Sun") and TimeOfDay between "08:00" and "14:00");

How do I now create another query to select * for the rest of the times? (Weekdays from 14:01 to 07:59 and Saturday/Sunday the entire 24-hour period)

Thank you

 

[PHV]

where WeekDay in ("Sat", "Sun") or not (TimeOfDay between "08:00" and "14:00")

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

 

[Taecca]

Thanks for your reply but it did not work.

Basically I need 2 reports: (1 for each period)

Period A is weekdays only from 8 to 14
Period B is every day except weekdays from 8 to 14

The query for period A is okay.

How do I do the query for period B?

 

[PHV]

And this ?
where WeekDay in ("Sat", "Sun") or TimeOfDay not between "08:00" and "14:00"

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

 

[Taecca]

Weekday cannot be Sat and Sun for the second query.

I need all week long except period A (which is Mon through Fri from 8 am to 14)

 

[PHV]

Some inconsistencies:

Weekdays from 14:01 to 07:59 and Saturday/Sunday the entire 24-hour period

vs

Weekday cannot be Sat and Sun for the second query

Perhaps you don't know the difference between 'And' and 'Or' ?
BTW, if your WHERE clause is more complex, you have to play with parenteheses:
where (WeekDay in ("Sat", "Sun") or TimeOfDay not between "08:00" and "14:00") And ...

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

 

[Taecca]

You are correct. I was getting confused with 'And' and 'Or'

All resolved.

Thank you