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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding weekends to a query?

Status
Not open for further replies.
skeelo

skeelo

Programmer
Aug 14, 2002
12
0
0
CA
This may seem a bit odd but I have an attendance query that needs to have Saturday and Sunday included. The odd thing is that I never did anything to it to NOT include them but it only gives me the weekdays. Originally that was OK but now I want to include them. Any ideas on what I may have unknowingly done? I never wrote any SQL either.
 
Sort by date Sort by votes
Can you open your query in design view, and select View, SQL from the menu. Then copy and paste & post it so I can see what the query looks like.

J. Jones
jjones@cybrtyme.com
 
Upvote 0 Downvote
Thank you for the reply....although I wont be able to send it until monday. I am not back to work until then.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Article
currentWeek excluding weekends
Replies
6
Views
122
strongm
strongm
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
296
dhookom
dhookom
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
298
combo
combo
Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
298
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
319
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top