Multiple items in one row
I have an Access database that can be used to reserve resources. The user inputs a date range and then checks off what they want to reserve. It looks like this:
StartDate .............EndDate .........Laptop......Camera........Projector
10/29/2007...........10/29/2007........................X
10/29/2007...........10/31/2007..........X
10/31/2007.......... 11/01/2007........................X..................X
Of course there is other info, and a return date, but none of that is needed for this report.
I want the report to show what is available. A blank means the item is available and the X means it is unavailable. It should look like this:
Date...............Laptop.............Camera..........Projector
10/29/07.............X.....................X
10/30/07.............X
10/31/07.............X.....................X..................X
11/1/07...............X.....................X
The dates in the report come from a date table which make up Group Header 1.
This is a sample of the formula I used to get the X's to show up in the Detail section.
if {DateTable.Date}>={Reservation.StartDate}and{DateTable.Date}<={reservation.EndDate}
then if {reservation.Laptop}=true
then "X"
This works but the x's from different reservations show up on different lines. I was able to get the first detail line to match up with the date, by choosing Underlay Following Sections, but the others still show up in a different line. For example 10/31/07 looks like this:
Date.........Laptop.........Camera.............Projector
10/31/07.........X
....................................X.....................X
Your help is much appreciated!

