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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Comparing tables in Access 1

Status
Not open for further replies.
maerts

maerts

Technical User
Oct 24, 2002
20
0
0
US
I have two tables in Access, one has all employees in it, the other only has some of the employees, how do you create a query that will compare the two tables and tell me which records are missing from the second table?
 
Sort by date Sort by votes
The easiest way is to select New from the Queries tab in Access and use the Find Unmatched wizard.
 
Upvote 0 Downvote
That worked great carrr, thank you, now I feel stupid
 
Upvote 0 Downvote
Don't.
Everybody learns to beat the curve...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

titanif
  • Locked
  • Question
Office 365- Spill A Table Column Into Another Tables Column
Replies
1
Views
89
SkipVought
S
ladyck3
  • Locked
  • Question
Excel 365 - Working with Tables - Calculating data from one worksheet to another. 2
2
Replies
30
Views
209
combo
combo
Cpreston
  • Locked
  • Question
Trim Multiple items in one column
Replies
2
Views
111
Andrzejek
Andrzejek
Andyri
  • Locked
  • Question
Limits in Excel 2
Replies
7
Views
102
Andyri
Andyri
grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
143
combo
combo

Part and Inventory Search

Sponsor

Back
Top