Query the record

[Guest]

There are Table A and table B which have the same field called C.
But table A has 20 record meanwhile table B has 19 records.
Now I have to query the last record (20th) from Table A which is not belong
to table B . As the result, in my Query, will show only the 20th record from
Table A.
How can I do?
I am looking forward to hearing from you all.

Thanks, Jason

 

[Granny Spitz via AccessMonster.com]

my Query, will show only the 20th record from
Table A.

SELECT TableA.C
FROM TableA LEFT JOIN TableB ON TableA.C = TableB.C
WHERE ISNULL(TableB.C);

 

[Guest]

Hi Jason,

If I understand you correctly, you want to display all records in Table A
that are not present in Table B, which in this case, is only one record (the
20th record). Is this correct? If so, try using the query wizard to create
this query. Click on the Queries tab in the database window. Click on the New
button. Select the last entry, which reads "Find Unmatched Query Wizard".
Follow the prompts.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Thank you so much 2 guys. I solved my problem directly.

 

[Granny Spitz via AccessMonster.com]

Thank you so much 2 guys. I solved my problem directly.

You're welcome, Jason. It wasn't half as hard as you thought it would be,
was it? <g>