By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,462 Members | 2,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,462 IT Pros & Developers. It's quick & easy.

How To use Minus Operator in access

100+
P: 190
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
May 22 '08 #1
Share this Question
Share on Google+
2 Replies


JustJim
Expert 100+
P: 407
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
May 26 '08 #2

JustJim
Expert 100+
P: 407
Hey, no problem. It was a pleasure to help you.

Jim
Jun 18 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.