how to know if a field is empty or not in a data macro

[mana]

hello

i want to check if a field in a query is empty or not but it is not working as i wrote it. i attached the pic. thank you for you help

 

[Ranman256]

in the sql
IsNull([field])

 

[JulianKirkness]

It looks to me as though you are looking up a record in [qry_developedchecks] and then testing fields in [developedchecks] - could this be the problem?