hi,<br><br>I am new to access. DO u have UNION / INTERSECT / MINUS in Access as in Oracle. I have 2 tables with similar data(primary key field is same). i need to compare other fields and report records where there is no match for a primary key. <br><br>Help me
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Union and intersect queries
- Thread starter jabond007
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
yes you can do union queriesin access<br>there is also a query wizard that will find unmatched records.<br>Have at it
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
