HELP! Report, or Spreadsheet?

[benbenson]

I am trying to display a calendar type form, cross referenced with room numbers (for the hotel where I work). I have got the table with a date field and roomNo being a composite key. I need the date along the top and roomNo down the side, and a booking ID field displayed in the intersecting cell. Got it? I suspect I may have to do it in excel, but dont really want to do this. Any Ideas?
p.s. is it possible to have command buttons on a report?

 

[Rich]

Use a Crosstab query/report for the first question, command buttons serve no useful purpose on a report

 

[benbenson]

Sorry, but im struggling! How exactly do I make a crosstab query/report? The purpose of the command button would be to book a room, i.e. enter a booking id.

 

[benbenson]

More problems! I have created the crosstab query. However, should I base it on the table or the query? The query requests a date period (start and end date) and brings up the records for that date. When I run the crosstab query, it cannot "bind name startdate ". Does this mean its not possible to have user entered criteria in a crosstab query?

 

[benbenson]

Ha! I've entered the between expression right, and assigned data types to the dates. This has eliminated the cannot bind message. Now, I receive the message "cannot evaluate expression"
the date field, being the column header has the criteria:

between [enter start date] and [enter end date]

Not that much of a complicated expression you'd think?!?