Duplicate records in query

[Christineg2]

Hi I am running a query where I have many records in table A and one record Table B. The problem is that when the records match it duplicates the record in table B which is not what I want to see.

[davegri]

If you mean it duplicates record b for each record a (resulting in 2x the number of records in a), then you have a cartesian join. Google it.

[Christineg2]

If you mean it duplicates record b for each record a (resulting in 2x the number of records in a), then you have a cartesian join. Google it.

I have uploaded what I mean. Thanks

[June7]

That's how queries normally work - all related data is displayed. Doing what you want in query is difficult. It is simple with a report by using textbox HideDuplicates property or report Sorting & Grouping feature.

[CJ_London]

you can do this with your query recordsource - see this link

https://www.access-programmers.co.uk...report.326715/

[Christineg2]

you can do this with your query recordsource - see this link

https://www.access-programmers.co.uk...report.326715/

This is perfect. Thank you for your assistance.