I have a query that is based on 2 tables, which have a on to many relationship. The first table is clients and the second is dispatches. I am compiling a label report to print off the addresses of any clients picked up by the query, but if the client has more than one dispatch record, their address is printed off more than once. Could someone please help me to somehow make the query only return distinct addresses.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Distinct records
- Thread starter RichyT
- Start date
Try grouping on CLIENT and showing the FIRST of their address information. This would get you only 1 record for each client regardless of the number of items per client.
Hope this helps.
Jim "Get it right the first time, that's the main thing..."![[wavey]](/data/assets/smilies/wavey.gif "[wavey] [wavey]")
Hope this helps.
Jim "Get it right the first time, that's the main thing..."
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
