K
Kass
I have a report based on a query (Bank Monthly). The Bank Monthly query is
based on a master query (Current Members) where I calculate the field [Bank
Fee] using the Val function to get the calculated field to display results as
a number rather than text (thanks to good advise off of this site!) Now I
want to show in my report a total for the [Bank Fee] field. I used the
formula: =Sum([Bank Fee]) and I get a data type mismatch error. I know the
formula works where I have it because I can substitue other fields that
weren't calculated in the Current Members master query and I get a sum. I
know the [Bank Fee] field in the Bank Monthly query is treated as a number
because I have the option to format it as currency, an fixed number, etc. in
the properties window. I can even do a running total on the [Bank Fee] field
and it works, so I think I an indeed working with a number in that field now.
Any ideas as to why it won't calculate a sum?
Thanks!
Kass
based on a master query (Current Members) where I calculate the field [Bank
Fee] using the Val function to get the calculated field to display results as
a number rather than text (thanks to good advise off of this site!) Now I
want to show in my report a total for the [Bank Fee] field. I used the
formula: =Sum([Bank Fee]) and I get a data type mismatch error. I know the
formula works where I have it because I can substitue other fields that
weren't calculated in the Current Members master query and I get a sum. I
know the [Bank Fee] field in the Bank Monthly query is treated as a number
because I have the option to format it as currency, an fixed number, etc. in
the properties window. I can even do a running total on the [Bank Fee] field
and it works, so I think I an indeed working with a number in that field now.
Any ideas as to why it won't calculate a sum?
Thanks!
Kass