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

Difference between tables 1

Status
Not open for further replies.
BrianLe

BrianLe

Programmer
Feb 19, 2002
229
US
I would like qryUnfinishedTrains to find the records in tblShedule that are not in qryFinishedTrains. The two "tables" (tblSchedule, and qryFinishedTrains) have the same fields (TrainNo, TrainPart, etc.). Any suggestions?

Thanks, Brian
 
Sort by date Sort by votes
Have you tried to follow the unmatched query wizard ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
1K
serino
serino
spartansFC
  • Locked
  • Question
Display Year between 2 dates 1
Replies
1
Views
871
dhookom
dhookom
serino
  • Locked
  • Question
Adding Records between two ranges 2
Replies
12
Views
1K
serino
serino
MDGarcia
  • Locked
  • Question
Error Could not delete from specified tables 2
Replies
14
Views
2K
MDGarcia
MDGarcia
leifoet
  • Locked
  • Question
SQL query with UNION ALL of 2 tables does not work
Replies
7
Views
554
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top