My query is a multiple table query across customer details, golf courses, hotels.
As i build the query say with just customer details, then it is fine in that the customer details, name,address etc appear only once.
The trouble starts when i want to know what courses they are playing at. If they are playing at 3 courses then the customer details appear on 3 separate lines with each golf course. If they are playing 5 times then 5 entries appear.
I want the 5 entries so i know what courses they are playing, but i only want the customer details once so i have Mr Jones of 123 Beach drive, playing Golf At Palm Springs, St Mary's, Alberta etc . So when i use the query in a report i get their address once but all the courses where they are playing.
As i build the query say with just customer details, then it is fine in that the customer details, name,address etc appear only once.
The trouble starts when i want to know what courses they are playing at. If they are playing at 3 courses then the customer details appear on 3 separate lines with each golf course. If they are playing 5 times then 5 entries appear.
I want the 5 entries so i know what courses they are playing, but i only want the customer details once so i have Mr Jones of 123 Beach drive, playing Golf At Palm Springs, St Mary's, Alberta etc . So when i use the query in a report i get their address once but all the courses where they are playing.