Crosstab Diary

[forman]

I've got a database that records booking of Cars.

I now need to show a 'Diary'

I was thinking [Car_Reg_No] across the columns, [Hire_Date] on the rows and the [Time_Of_Hire] in the value area.

Problem : Can't get the value [Time_Of_Hire] in crosstab.

Any thoughts......Anyone


Thanks

 

[manu]

Pls clarify your objective & type of calculation you want to perform

 

[forman]

Basically I want to have a Diary sheet.

I want to end up with dates down the left side and car registration numbers across the top and the values in the grid being the times when the cars are booked.


Thanks