Too many records in my golf query !!

[MarkyP]

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.

 

[steelhead]

Can you put the customer information in the report header and the golf course information in the report detail?

 

[Pat Hartman]

I would use a main report to show the information about the customer and two subreports. One for golf courses and the other for hotels.