V
Vincent Johns
tmaxwell said:Vincent,
I fixed the first 2 problems, but I am still getting an "type mismatched
expression" would this be from Q_combo? It works fine.
SELECT Q_Combo.Branch, Q_Combo.number
FROM Q_Combo LEFT JOIN NAMEADDR on (Q_Combo.Branch =
NAMEADDR.[co-number]) AND (Q_Combo.number = NAMEADDR.[cust-number])
WHERE (((NAMEADDR.[co-number]) Is Null))
ORDER BY Q_Combo.Branch, Q_Combo.number;
Any thoughts?
Todd
I plugged this code into a new Query in my database (in Access 2000,
using the same Tables that I cited in a previous posting on this
thread), and it worked without problems, giving me the results I expected.
To determine where your "type mismatched expression" comes from, you
might make a copy of the Query and try running it several times,
removing a small part each time. When you no longer get the error
message, you probably just then removed the part of the Query that was
giving rise to the message.
-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.