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";