Null NZ IIF

[MM-UK]

I need the following to handle Nulls but not sure which option to use.

=(DSum("TG","tblLabourBooking","AssessmentNo=" & [AssessmentNo] & " And Operation='Fit'"))

Thanks in advance

MM

 

[FoFa]

How about:
=(DSum("TG","tblLabourBooking","AssessmentNo=" & [AssessmentNo] & " And Operation='Fit' AND TG IS NOT NULL"))
Or whatever you want to check for null

 

[MM-UK]

Sorry, that didn't work.
Does any body else have any idea's ?

 

[MM-UK]

Perhaps I should have mentioned, this is a text on a form as opposed to a criteria in a query.

 

[FoFa]

OK how about:
=ISNULL(DSum("TG","tblLabourBooking","AssessmentNo=" & [AssessmentNo] & " And Operation='Fit'"),"DANG THING WAS NULL")
if your DSum returns NULL, you would get DANG THING WAS NULL instead.

 

[bradcccs]

DSum accounts for NULL values already (doesn't it? - Does in my tests)

Or are you trying to allow for [AssessmentNo] being Null?

What error are you getting?

 

[MM-UK]

In the field in question, I am getting #Name?

I've checked the field names are correct in the table, here's what should happen.

=(DSum("TG","tblLabourBooking","AssessmentNo=" & [AssessmentNo] & " And Operation='Fit'"))

The expression looks for TG which is a numerical value assigned earlier in the database.
If there is no data, I would like toi return a zero instead of #Name?

I have about 6 fields with this expression and only the "Fit" changes in each.
Where there is data, the expression works fine.
Its only where there is no data for that record.