Changing when a day starts and ends

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 06 Jul 2006 16:52 GMT

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

Reply to this Message

Allen Browne - 06 Jul 2006 16:57 GMT

Perhaps:
>= DateAdd("h", 6, [Forms]![frmEntry]![StartDate])
And < DateAdd("h", 6, [Forms]![frmEntry]![EndDate])

Signature

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.

> 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
[quoted text clipped - 3 lines]
> report is from midnight to midnight, so it always includes part of the
> previous day's trading.

Reply to this Message

Klatuu - 06 Jul 2006 17:06 GMT

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.

> 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
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message