Beginner RRS feed

  • Question

  • Hi

    I am trying to design a query that shows activity by date.

    as an end product at this stage, I would like something like:

    DATE (or date range)

    COTTAGE1 > is there guests leaving on this date/ is there a booking in

    next COTTAGE if any activity for the date above

    and then NEXT DATE

    [so a summary of activity by date]

    what would be one approach of designing tables

    then the query please?

    Many thanks

    Friday, March 18, 2016 2:20 PM