using Nz function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I searched for and read posts on this group regarding using the Nz function,
but I can't seem to get it to work for my purposes. In my report, I have a
currency field [Cost]. I want to show [SumOfCost] in the report footer. The
report is filtered by date range. If there are no costs for a particular
date range, I want the [sumOfCost] field to show "None", otherwise show the
sum of the costs listed above.

I have tried all the different suggestions from you experts, plus all sorts
of variations, and nothing seems to work. Do I need to have something show
in the detail section even if there are no costs for the date range? Right
now, the detail section is blank, and the [SumOfCost] field shows "#Error" if
there is no data. Seems like it should be simple and straightforward, but I
must be missing something obvious! Thanks in advance...you have helped me
tremendously in the past!
 
Perfect! I know I could count on one of you to help!

Susan

Ofer said:
Sorry, I forgot about the none

=IIf(HasData, Sum([FieldToTotal]),"None")

--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benefit from it.

Good luck



Susan said:
I searched for and read posts on this group regarding using the Nz function,
but I can't seem to get it to work for my purposes. In my report, I have a
currency field [Cost]. I want to show [SumOfCost] in the report footer. The
report is filtered by date range. If there are no costs for a particular
date range, I want the [sumOfCost] field to show "None", otherwise show the
sum of the costs listed above.

I have tried all the different suggestions from you experts, plus all sorts
of variations, and nothing seems to work. Do I need to have something show
in the detail section even if there are no costs for the date range? Right
now, the detail section is blank, and the [SumOfCost] field shows "#Error" if
there is no data. Seems like it should be simple and straightforward, but I
must be missing something obvious! Thanks in advance...you have helped me
tremendously in the past!
Click to expand...
Click to expand...
 
Back
Top