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
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