Instead of using something like this:
Nz([Your Field], [Value If Your Field Is Null])
try using something like this:
IIf(IsNull([Your Field]), [Value If Your Field Is Null], [Your Field])
Nz is an Access-specific function that is only "understood" in queries
executed within Access.
"Rob" <(E-Mail Removed)> wrote in message
news:F0EFB2A3-669A-4D8C-8D06-(E-Mail Removed)...
> I do a query on a crosstab in order to get my information in the format I
need it.
>
> My initial problem was that the crosstab returned null values, and my
query therefore returned null values as results to my arithmetic
calculations. I fixed this using the nz() function.
>
> Now my problem is that when I try to refresh the ODBC query I have into
excel I get a message telling me that the access ODBC driver doesn't like
the nz function.
>
> Am I maybe going about this the wrong way??
>
> Thanks
> Rob
|
