Help with Nz or nulls in query

[ezpc]

I'm trying to run a report based on this query(qryCSAP_Crosstab).

This particular field in the query (Not Tested) may not have any data and I'd like to display zeroes in the column.

I'm struggling with the Nz function and just can't seem to get the syntax right. I'm not sure if it's because it's in a crosstab query or what.

Any help would be appreciated.

 

[Mile-O]

I can't see your database as I have Access '97 but the syntax should be:

NewField: Nz([YourField], 0)

 

[neileg]

I can open your database but since the query relies on linked tables that aren't there, I can't see anything useful.

 

[ezpc]

Doh!!!

Omigod I am so sorry. Here is the file with the tables