How would you write a SELECT statement to find the values that are NOT EQUAL to a value of H in the following query and the values CAN BE EITHER NULL or EMPTY for field Manual??
I am writing a query in Access 2003 using an MDB type file.
How would you write a SELECT statement to find the values that are NOT EQUAL to a value of H in the following query and the values CAN BE EQUAL TO EITHER NULL or EMPTY for field Manual?
SELECT tblBanks.*, tblDates.dtRec, tblOpenItems.*
FROM tblDates, tblBanks INNER JOIN tblOpenItems ON tblBanks.[Bank Code]=tblOpenItems.Bank
WHERE tblOpenItems.t In ("A","D","E") And tblOpenItems.Manual<>"H";
How would you write a SELECT statement to find the values that are NOT EQUAL to a value of H in the following query and the values CAN BE EQUAL TO EITHER NULL or EMPTY for field Manual?
SELECT tblBanks.*, tblDates.dtRec, tblOpenItems.*
FROM tblDates, tblBanks INNER JOIN tblOpenItems ON tblBanks.[Bank Code]=tblOpenItems.Bank
WHERE tblOpenItems.t In ("A","D","E") And tblOpenItems.Manual<>"H";
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
David Kroll
WHERE tblOpenItems.t In ("A","D","E") And (tblOpenItems.Manual is NULL or tblOpenItems.Manual <>"H");