Find Unmatched records

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have 2 queries, classes required, and classes completed.
What I am looking to do now is find the records in the
classes required query that do not have an exact match in
classes completed. (Exact match means ALL fields are the
same) The new query would have to compare for ANY
difference and show all records that do not see an exact
match. Please send the answer to my email as well as
posting here please.
 
Tom,

I have just done a similar exercise which compares field for field two tables and marks those records that are different. (it would then be simple to view/make table of the marked records). But I can't see yr email address here so can't email you what I did ( ok I don't know how to find email addresses here). Email me at (e-mail address removed) and maybe we can fix.

regards
Laurie Eaton
 
How about using the unmatched query wizard?

It should do exactly what you want.

FYI, questions asked in the groups get answered in the groups. Asking for
direct emails implies that you are willing to hire and pay someone for your
answer.

See http://www.mvps.org/access/netiquette.htm

Good luck

Sco
 
Unmatched query wizard will not work. (I have tried every
variation of this with no luck) As for the getting answers
sent to my email direct,I apologise for not being
fully "netiquely correct", but I have helped several
people in exactly that way myself. Responces are a lot
quicker and I have developed a few "friends" that share
code in exactly this manner. I hope to gain more in this
group.
 
Unmatched query wizard will not work. (I have tried every
variation of this with no luck) As for the getting answers
sent to my email direct,I apologise for not being
fully "netiquely correct", but I have helped several
people in exactly that way myself. Responces are a lot
quicker and I have developed a few "friends" that share
code in exactly this manner. I hope to gain more in this
group.
 
Back
Top