Search results

Thanks for the reply. Tried that, same error message: "Wrong number of arguments used with function in query expression" SQL below, Access put in the extra () around [Number], not my doing. TRANSFORM Count(Nz([Number],0)) AS [Incident Count] SELECT QryNewData2.[Pass/Fail] FROM (QryNewData2...

Hi, have been working on this one for 2 days and getting nowhere, have searched forums, books etc but still no joy. I have the crosstab query below in Access 2000 which returns some Null values. For graphical representation these need to be zeros. I have tried various incarnations of the Nz...