Showing Where Data is Missing in a Query

[whitestone]

I want to use a column in a query to show where data is missing in other fields.

In excel I have used this statement:

=IF(COUNTA(I5:J5)=2,"","error")

Basically, I have two fields PRICE and WEIGHT. I want a column in the query to show 'Error' (or any kind of flag) when either (or both) of these fields are blank.

Hope this makes sence.

Any advice?

Thanks

 

[Alc]

You could add to the third column something like

=IIf(IsNull([Price]),"Error",IIf(IsNull([Weight]),"Error",""))