Totals

  • Thread starter Thread starter administrator
  • Start date Start date
A

administrator

I have a report which runs from a crosstab query. I have
a field I've added on the report which adds the five $
columns in my query. However, if there is no value in the
field, I don't get a total. I'm not very good at
programming but surely there is some IIf statement I can
make in the total field of the report that says "If empty,
add zero."

Help.
 
Where do I place this?
-----Original Message-----
You can use the Nz() function.
Nz([FieldName],0)

--
Duane Hookom
MS Access MVP


I have a report which runs from a crosstab query. I have
a field I've added on the report which adds the five $
columns in my query. However, if there is no value in the
field, I don't get a total. I'm not very good at
programming but surely there is some IIf statement I can
make in the total field of the report that says "If empty,
add zero."

Help.
Click to expand...


.
Click to expand...
 
It would help if you provided the expression you are using which "adds the
five $ columns...." and how/where you are using it.

--
Duane Hookom
MS Access MVP


administrator said:
Where do I place this?
-----Original Message-----
You can use the Nz() function.
Nz([FieldName],0)

--
Duane Hookom
MS Access MVP


I have a report which runs from a crosstab query. I have
a field I've added on the report which adds the five $
columns in my query. However, if there is no value in the
field, I don't get a total. I'm not very good at
programming but surely there is some IIf statement I can
make in the total field of the report that says "If empty,
add zero."

Help.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top