Too many records in my golf query !!

MarkyP

New member
Local time
Today, 14:04
Joined
Feb 8, 2006
Messages
7
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.
 
Can you put the customer information in the report header and the golf course information in the report detail?
 
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.
 

Users who are viewing this thread

Back
Top Bottom