Nz and IsNumeric not working

[natep26]

I've looked at multiple threads concerning working with null values and how to get a hard number in place of the #error message. I have tried multiple ways and none seem to work. Am I overlooking something.


In my query the Column ABC comes up with a number from a calc in another query or '#error ' because there is no data for that record. I need to capture the #error and replace it with the value from another table.

This is what I have

ABC: nz([ticsqmonthlies].[ABCAvg],[ticsqinfo].[ABC])

Where there is info for the record from ticsqmonthlies, I get the correct value of ABC. Where there is no data, I still get #error.

Thanks for your help.

 

[Rich]

There's a difference between records with null values and no records' make the original query produce records

 

[natep26]

Thank you sir...That's what I was looking for. It's all working now.

 

[dkinley]

Use ...

Len(Nz([FieldName], "")) = 0

In this manner you cover the zero length fields and the null fields for your evaluation.

-dK