Search results

  1. C

    Crosstab Query the best option?

    I have been struggling with this report issue for awhile. I would appreciate any thoughts/insights. I have a table called invoices, which contains the following fields INVOICEID GUESTID BOOKINGSID InvoiceDate RoomNo PRODUCTID - contains rooms/massage/taxi/extrabed/ (lookup) Amount PaymentType -...
  2. C

    Auto Generate report or records from table

    HI, I am hoping for some help please. I have a table called bookings, three records within that table are; arrivaldate departuredate breakfast This Table (Bookings) is linked to the guest table via GUESTID Assuming that a guest arrive on the 5th and leaves on the 10th, I am trying to create...
Top Bottom