I'm doing a database which will pull data into an Excel report. Some of the data I get out of a pivot table, in this case values for each month (period). Not all fields have data, so when I paste the pivoted data into an Access table I get null fields.
What I then want to do is sum up the values for each month, which are split into two, Mob and Exp. I ran across the null value problem but thought I'd fixed it with the Nz function. However, as the data is to be pulled into Excel using a macro, it won't let me use the Nz function.
At the moment, the formula in the query in Access for, in this case, the P1 field has the following in it:
I thought I could make it work with something like:
But no luck... Any help is much appreciated.
What I then want to do is sum up the values for each month, which are split into two, Mob and Exp. I ran across the null value problem but thought I'd fixed it with the Nz function. However, as the data is to be pulled into Excel using a macro, it won't let me use the Nz function.
At the moment, the formula in the query in Access for, in this case, the P1 field has the following in it:
Code:
P1: Nz([P1_Mob])+Nz([P1_Exp)]I thought I could make it work with something like:
Code:
P1: IsNull([P1_Mob],0)+IsNull([P1_Exp],0)But no luck... Any help is much appreciated.
