WHERE -IIF ?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top