How To use Minus Operator in access

[Shalini Bhalla]

I want to extract records form a table . I have Table A and Table B . I want to extract unmatching records from table A to table B ....


Can you Please tell me how to extrat it ? How to make use of minus in access

[JustJim]

I want to extract records form a table . I have Table A and Table B . I want to extract unmatching records from table A to table B ....


Can you Please tell me how to extrat it ? How to make use of minus in access

Hi,
There is a query wizard that will find unmatched records between two tables. I suggest that you try that then look at the query design view or SQL view of the query that the wizard makes so that you can understand it and then it will be easy to make unmatched record queries yourself.

To find the unmatched query wizard, just click on New in the query view of the database window.

Jim

[JustJim]

Hey, no problem. It was a pleasure to help you.

Jim