kiwipeet
Programmer wannabe
- Local time
- Today, 23:07
- Joined
- May 13, 2008
- Messages
- 25
Hi
I am trying to write a query to report vehicle utilisation of fleet cars.
I have records for each booking with a start and end date. The booking could start and finish on the same day, or could span many days.
I want to expand each record that I have one entry for each day of the booking. For example:
11/01/2010 15:30 12/01/2010 16:00
would become
11/01/2010 15:30 12/01/2010 23:59
12/01/2010 00:01 12/01/2010 16:00
Can this be done with a query? or is this a VBA question?
Any help would be greatly appreciated.
Thanks in advance.
Pete
I am trying to write a query to report vehicle utilisation of fleet cars.
I have records for each booking with a start and end date. The booking could start and finish on the same day, or could span many days.
I want to expand each record that I have one entry for each day of the booking. For example:
11/01/2010 15:30 12/01/2010 16:00
would become
11/01/2010 15:30 12/01/2010 23:59
12/01/2010 00:01 12/01/2010 16:00
Can this be done with a query? or is this a VBA question?
Any help would be greatly appreciated.
Thanks in advance.
Pete