Previous Thread

7/6/2006 4:53:17 PM    Changing when a day starts and ends
I have a sales report that is setup from a query with a parameter for date - 
 
Between Forms!frmEntry!StartDate and Forms!frmEntry!EndDate.  I have been 
 
asked whether it is possible for the report to have the period as '06:00 Day 
 
1 to 06:00 Day 2'? Currently the client cannot reconcile the billings with 
 
the cash in the till at the end of the evening, because the report is from 
 
midnight to midnight, so it always includes part of the previous day's 
 
trading. 
 
Thanks



7/6/2006 11:57:32 PM    Re: Changing when a day starts and ends
Perhaps: 
 
And < DateAdd("h", 6, [Forms]![frmEntry]![EndDate]) 
 
-- 
 
Allen Browne - Microsoft MVP.  Perth, Western Australia. 
 
Tips for Access users - http://allenbrowne.com/tips.html 
 
Reply to group, rather than allenbrowne at mvps dot org. 
 
"Mark" <mark5437DELETE@hotmail.com> wrote in message 
 
news:4h4ppoF1pqa6cU1@individual.net...