By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,323 Members | 2,008 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,323 IT Pros & Developers. It's quick & easy.

Convert a field, Join 2 tables and find unmatched, all in one query

P: 77
Please Help....

I have a query with 2 tables, LegalFile and Cases.
LegalFile has the field CaseID(Number Field) and Cases has CaseNbr(Text Field).
I am trying to find entries that are in Legalfile but not in Cases.
In order to club the conversion and join in one query I has the criteria for LegalFile.CaseID set to Int([CaseNbr]). With this setup if I run the query it gives me all entries that are common in LegalFile and Cases.
I tried setting Cases.caseNbr criteria to Is Null to get all records that are in LegalFile but not in Cases, that gave an error saying 'Type Mismatch'.
So is it possible to do all this in one query,

Convert a Field, Join two tables and Find Unmatched?

Please help...

Thanks in advance
Dec 18 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,392
Do the conversion in a subquery in the FROM clause. Then the rest is your standard find unmatched query.
Dec 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.