Search results

  1. J

    How to limit a certain amount of records.

    Hi, I have a Booking ID form which you enter in bookings made by customers. There are multiple Customer IDs which can make multiple Bookings (Booking IDs). They book certain Trips (Trip IDs) to go on. What I'm trying to do, is make it so that I can only allocate 20 customers to a Trip ID and no...
  2. J

    Selecting the last record from each customer before a certain date.

    Hi, I want to have a query which is attempting to find a list of customers who haven't make a booking for 6 months. Each customer has a separate ID, they make a booking are each stored in a Booking ID table. I currently have it so that the Departure date is set to <Date()-180, meaning that all...
Back
Top Bottom