Creating a simple reservation events report RRS feed

  • Question

  • Hello

    We have a database collecting room reservations including time event start and end, and the room name.

    Can someone tip how to build a simple access report showing the room names on the top of each column, the time start and end, and the event title, for just one day at the time?



    Tuesday, October 27, 2015 12:49 PM

All replies

  • A crosstab query may be able to do that.

    For the vertical axis you may need to join with a helper table with one record for each period.

    If you want to include columns with no data (like the Room 4 and Room 5 column) you will need to specify column headings in the query design properties.

    -Tom. Microsoft Access MVP

    Tuesday, October 27, 2015 2:01 PM