On Aug 8, 10:54 am, "Larry Linson" <boun...@localhost.notwrote:
Is there some reason not to use the Find Unmatched Query Wizard to generate
the pattern and then use that as the basis for your VBA code?
Just an idle question: what is the definition of the "user curriculum"
field? If it is not a unique value for each record, you will have to
further clarify what makes the records different.
Larry Linson
Microsoft Access MVP
"Jim" <jlrehm...@gmail.comwrote in message
news:11**********************@x40g2000prg.googlegr oups.com...
How do I program visual basic to create a "Find Unmatched Query"?
I have two tables:
- TodaysImport
- YesterdaysImport
Both tables have the same 6 fields:
- User
- User Name
- Curriculum
- eMail
- OpGroup
- UserCurriculum
The UserCurriculum field is the key field that I want to find the
unmatched records on. I want the results from TodaysImport to show me
the records that were not in the table YesterdaysImport.
Any help would be appreciated!- Hide quoted text -
- Show quoted text -
You're right Larry, I didn't think about it. Here's the SQL from the
query, so how do I get Access to create the query?
SELECT TodaysImport.User, TodaysImport.[User Name],
TodaysImport.Curriculum, TodaysImport.eMail, TodaysImport.OpGroup
FROM TodaysImport LEFT JOIN YesterdaysImport ON
TodaysImport.UserCurriculum = YesterdaysImport.UserCurriculum
WHERE (((YesterdaysImport.UserCurriculum) Is Null));