I have a "[strVendorName]" Footer section
In that section I have a calculated text box: =Sum([curInvoiceTotal])
Provides an invoice subtotal for each vendor's name
In the Detail section there is a field generated from the query the report is based on
Funding Code:[strAubrey/Providence]&""&[intFundingCode] which adds the letter A or P in front of the
[intFundingCode] field.
I would like to create a calculated field in the Report Footer that provides a grand total for all Funding Code's that begin with the letter A and a grand total for all the P Funding Codes as well.
I tried creating a text box with this expression but it does not work: =IIF([intFundingCode]=a*,sum([intFundingCode],0
If someone could please tell me how to get these grand totals, I would appreciate it. Thanks