Query to ignore records where both fields are null

[dccjr]

I have been looking through the forums for a solution. I have tried various forms of the following:

SELECT WorkOrderNo, QualityNo FROM RCAData1 WHERE NOT WorkOrderNo ="" And QualityNo ="" ORDER BY RCAData1.WorkOrderNo;

My problem is that I need to ignore the record if both are "" or both are null or possibly one of each.
The synatx for this has my head pounding. Or maybe it is from banging it on the table.

[June7]

I don't allow empty strings in tables.

SELECT WorkOrderNo, QualityNo FROM RCAData1 WHERE WorkOrderNo Not Is Null AND QualityNo Not Is Null ORDER BY WorkOrderNo;

If there is possibility of either empty string or Null:

SELECT WorkOrderNo, QualityNo FROM RCAData1 WHERE Nz(WorkOrderNo,"")<>"" AND Nz(QualityNo,"")<>"" ORDER BY WorkOrderNo;

[dccjr]

Funny thing, I copied it into my code and I got "Syntax error missing operator in query expression 'Nz(WorkOrderNo,")<> AND Nz(QualityNo,")<> "ORDER BY WorkOrderNo;'.

The funny part is that if I paste it in the SQL view, it works perfect. Ideas.

The I got it. Stupid me forgot to replace the "" with '', as it is defined in a string. Works great!!! Thanks for the help.

For future reference, what is Nz?

[June7]

Nz is an intrinsic Access/VBA function. Use it to supply an alternative value if field is Null. In this case, I converted Null to empty string.