Changing when a day starts and ends

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

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
 
To be able to do this, your data must be saved with times in it, or it will
not compare correctly. If they do have times, then you can provide the time
with the date for the criteria and it should return only rows within the time
criteria.
 
Back
Top