G
Guest
I have a tour bus reservation system and have an interesting challenge. I
need to build a crosstab query to show how many buses of each type have been
reserved for each day in the future.
The reservation system includes these fields needed for the crosstab:
BusType (values can be 55 passenger, 47 passenger or school bus)
LeaveDate
ReturnDate
I envision the crosstab will have a sequential list of 30 dates in the left
column (12/1/06, 12/2/06, ...), BusType as the column headings, and bus
counts in the crosstab cells.
The challenge is that buses can be out for several days so I can't just do a
count by leave date. I have to do a count of buses that are out in a date
range.
How can I write a query that counts the number of buses for each day in the
future for each bus type?
bob4
need to build a crosstab query to show how many buses of each type have been
reserved for each day in the future.
The reservation system includes these fields needed for the crosstab:
BusType (values can be 55 passenger, 47 passenger or school bus)
LeaveDate
ReturnDate
I envision the crosstab will have a sequential list of 30 dates in the left
column (12/1/06, 12/2/06, ...), BusType as the column headings, and bus
counts in the crosstab cells.
The challenge is that buses can be out for several days so I can't just do a
count by leave date. I have to do a count of buses that are out in a date
range.
How can I write a query that counts the number of buses for each day in the
future for each bus type?
bob4