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

Show this weeks records 1

Status
Not open for further replies.
Apollo13a

Apollo13a

Technical User
Apr 27, 2003
277
US
My query contains dates for entered labor hours. How do I show just the records for the current week? My payroll period runs Mon to Sun.
Thanks, Jim
 
Sort by date Sort by votes
the records for the current week
... WHERE Format([date field],'ww')=Format(Date(),'ww') ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Another solution is:

Code: 
 WHERE (((DatePart("ww",[LaborDate]))=Format(Now()-1,"ww")))

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
458
Andrzejek
Andrzejek
serino
  • Locked
  • Question
Adding Records between two ranges 2
Replies
12
Views
713
serino
serino
TrekBiker
  • Locked
  • Question
Find records containing another field value 1
Replies
9
Views
481
Andrzejek
Andrzejek
supportsvc
  • Locked
  • Question
How to limit the number of records based on the quantity in a field? 1
Replies
8
Views
582
supportsvc
supportsvc
Moss100
  • Locked
  • Question
Populate combo on for with distinct current records
Replies
1
Views
228
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top