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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding Unmatched Query

Status
Not open for further replies.
mosmas

mosmas

Technical User
May 22, 2003
61
US
Hello:

I have a database that has two tables, one tblCurrent and the other tblPrevious. Each of these tables has 10 identical fields.

What I need to do is to check if there is anything that has changed from the previous table. So, I need a query that will display a datasheet of those fields whose entries has changed from the previous table. Can anyone help?

Moses M.
 
Sort by date Sort by votes
One of the query wizards is "Find Unmatched." Will that do what you want?

Tom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Delete query takes FOREVER to run 1
Replies
11
Views
220
jedraw
jedraw
Moss100
  • Locked
  • Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
98
dhookom
dhookom
BradCustom
  • Locked
  • Question
Convert Access query to SQL query
Replies
5
Views
143
strongm
strongm
Bill6868
  • Locked
  • Question
Query Expression Question
Replies
3
Views
107
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Need help finding where a number lies within a set of values 1
Replies
3
Views
113
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top