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.
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.
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.
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
you can do this with your query recordsource - see this link
https://www.access-programmers.co.uk...report.326715/
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.