Total currency column in report

[ccampbell107]

I created a query for monthly billing. In a new field called charge, I
created an iif statement. If one column is null, the charge is one thing and
if another column has information, the charge is something different. I
formatted this new field as currency. When I pull the field into a report,
it doesn't allow me to total the column. It acts like the information is not
numerical. Is there a way to total the column?

 

[Clifford Bass]

Hi,

What are the data types of the columns involved? What is in the actual
IIf() function? When you say you formatted it as currency, how did you do
that? And where did you do that?

Clifford Bass

 

[ccampbell107]

I generate a query that has two columns from the table - one is named intake
and the other is followup - they both have dates in them. I generate a new
column named charge. the iif statement goes something like this: if there is
a date in the followup column, then the charge is $125.00, otherwise the
charge is $225.00. This seems to work correctly.
In the query, the column named charge is formatted as currency. When I dump
all three columns into a report, I do not get the option to total the charge
column, only to count records or values.

 

[Clifford Bass]

Hi,

This is odd. It works for me. Question: Does your IIf() function look
like this:

Charge: IIf(IsNull([Followup]),225,125)

or this:

Charge: IIf(IsNull([Followup]),"$225.00","$125.00")

Or something different? If the second, change it to the first. Also,
it is not necessary to format the query column. Just format the report
column. Also, you could just try adding a text box in the footer that has
this for its Control Source:

=Sum(Charge)

Hope that helps,

Clifford Bass