How to prevent duplicate records when joining two tables

[som3on3_10]

Hello,



How do I prevent duplicate records when joining 2 tables in Access? For example if both tables have an "ID" field and Table A has one record with ID 123, but Table B has two records with ID 123. When I join Table A to Table B using a left join, I get 2 records where ID = 123. I only need to retrieve 1 record. Sorry, joining tables is kind of new to me. TIA!

[June7]

If these tables have a many-to-1 relationship, that is expected. Why are you joining the tables? Show sample data and expected results. Quite possibly you need to do an aggregate Totals (GROUP BY) query or build a report using Grouping & Sorting features.

[som3on3_10]

So are you saying that I should query from Table B and group the ID field which will eliminate the dups and then join Table A with this new query?

[June7]

That's one way to go.

[som3on3_10]

Cool I will give it a try. Thanks for the help.