Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Specific days only 1

Status
Not open for further replies.
jw5107

jw5107

Technical User
Jan 20, 2004
294
US
I need to run a query to shows Friday, Saturday and Sunday for a specific date range...
I looked around, but can't find any working examples of what I need... DatePart or DateAdd, etc.....???

Any examples or suggestions??
Thanks in advance!!
jw5107
 
Sort by date Sort by votes
How 'bout
Code: 
WHERE WeekDay([SomeDateField]) IN (1, 6, 7)

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]
 
Upvote 0 Downvote
Golom,

Thank you very much!!! Especially for the quick response!!
Star for ya!! This is exactly what I needed!!

jw5107
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

03Explorer
  • Locked
  • Question
make a field within a query to increment values for purpose of output only 1
Replies
11
Views
606
03Explorer
03Explorer
Bennie47250
  • Locked
  • Question
Replace only if the last character of a field is a specific character 1
Replies
7
Views
682
Andrzejek
Andrzejek
ptrifile
  • Locked
  • Question
# Business Days
Replies
3
Views
229
MajP
MajP
MattGreer
  • Locked
  • Question
Query with COUNT, but only if there's not an entry in a many-to-many relationship
Replies
2
Views
183
MattGreer
MattGreer
TJVFree
  • Locked
  • Question
Number of days to go and past days in a month 2
Replies
4
Views
230
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top