Code in report

  • Thread starter Thread starter Mavis
  • Start date Start date
M

Mavis

Hi All,

Can tell me what is wrong with my below code?

=Sum((IIf(IsNull([DatePaid]),0,([InvoicedAmount]/[InvoiceROE])))+Sum([P&I
Credit])+Sum([P&ICredit]))
 
Hi,

The fulll error message is as below.
"cannot have aggregate function in expression
=Sum((IIf(IsNull([DatePaid]),0,([InvoicedAmount]/[InvoiceROE])))+Sum([P&I
Credit])+Sum([P&ICredit]))."
I have 3 fields in the report. The 3 fields are a result from diff formula.
i will like to sum up the results of the 3 fields.



Software-Matters via AccessMonster.com said:
What happens when you run it? What error message do you get? What are you
trying to achieve?
Hi All,

Can tell me what is wrong with my below code?

=Sum((IIf(IsNull([DatePaid]),0,([InvoicedAmount]/[InvoiceROE])))+Sum([P&I
Credit])+Sum([P&ICredit]))
Click to expand...

--
http://www.software-matters.co.uk/bespoke-database-design.html
Bespoke Access Database Development
Software Matters
Straightforward solutions that work

Message posted via AccessMonster.com
Click to expand...
 
Back
Top