Query Duplicates

[ygilbert]

Hello there...

I have two tables within Access 2007. I would like to create a query that takes the ID from Table A and returns the sex in Table B. However Table B has multiple copies of the same ID. How can I retrieve only 1 record of data from Table B without having the query generate the multiple records in Table B as well.

Thanks

YG

 

[Richard Schollar]

Hi

The SQL would look something like:

SELECT DISTINCT TableA.ID, TableB.Sex FROM TableA INNER JOIN TableB ON TableA.ID = TableB.ID

I have made assumptions about your TableB structure - that it has a linking field called ID that maps to TableA's ID field. You can click on the SQL view for the query you are creating and copy the above in.

 

[ygilbert]

Thanks I'll try this and get back to you. How do I switch from the SQL view back to the table view?

 

[Richard Schollar]

One of the toolbar/ribbon buttons is a dropdwon from which you can select the view you want (so you can switch easily between datasheet, design and SQL view).

 

[ygilbert]

got it to work...many thanks!