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!

Retreive Records that go past 12AM.

Status
Not open for further replies.
lcutliffe

lcutliffe

IS-IT--Management
Dec 1, 2006
30
US
Company is starting night shifts which are going to have employees clocking in and working past midnight. This is causing our current time and attendance reports to not work as they pull records from 12am - 12am. We need the report, when refreshed to pop up a parameter asking for the day and have it capture data from 4am - 4am. Not really sure how to do this.
 
Sort by date Sort by votes
You could use 'DateAdd' to subtract four hours and bring the data into line with the existing system. You'd need some method of recognising night-shift cases.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP [yinyang]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Brian S
  • Locked
  • Question
Splitting names that have variable numbers of spaces 1
Replies
5
Views
247
Brian S
Brian S
AleXSR700
  • Locked
  • Question
How can I make variable that is re-defined per section and readable in same-section formula? 2
2
Replies
20
Views
481
AleXSR700
AleXSR700
socalvelo
  • Locked
  • Question
Limiting the number of records in groups and sub-reports 1
Replies
2
Views
124
socalvelo
socalvelo
nerdygirlgear
  • Locked
  • Question
Limit sub report records to a time range on main report 1
Replies
1
Views
95
hilfy
hilfy
wantj43
  • Locked
  • Question
I have an Access 2016 form that con
Replies
1
Views
111
pmax9999
pmax9999

Part and Inventory Search

Sponsor

Back
Top