Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

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";
0
zimmer9
Asked:
zimmer9
1 Solution
 
peter57rCommented:
WHERE tblOpenItems.t In ("A","D","E") And nz(tblOpenItems.Manual,"")<>"H";
0
 
David KrollCommented:
WHERE tblOpenItems.t In ("A","D","E") And (tblOpenItems.Manual is NULL or tblOpenItems.Manual <>"H");
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now