none
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?

    Example:

    Thanks

    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