I have a report that sums a dollar amount by Account. The control source formula for the Account name also tells me how many transactions were compiled for the total.
=[Account] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record") & ")"
This is all good.
When I export this report to Excel using the external data menu option, the field "Account" says "Sum Of SumOfPayment" for each account.
Any help on resolving this so the report exports to excel the same way the report reads in Access would be greatly appreciated.