Null Values

[AndyShuter]

I know this probably sounds a bit thick, but this particular problem is really annoying me.

I'm executing a query that has a posibility of returning a Null value based on certain matches in criteria. (The result is based on COUNTING TEXT records) As I want to involve that search at a later date in another aggregate function, I need to turn the Null result into zero. I've seen some stuff about the Nz function but I can't seem to get it to work - it just seems to keep returning a Null value !

Any suggestions please???

 

[Mile-O]

In your query, it's simply a case of

Field - YourFieldName: Nz([FieldWithNullValues],0)

 

[AndyShuter]

Still Stuck

Sorry - do I create a new field or enter this into the existing criteria box???