using sumif in an access report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

greetings,

I need to use something similar to sumif from excel in an access report. for
example on a table I have colums showing base fare and the currency code the
ticket was booked in in another column.I want to sum the base fare by
currency within the report. Currently I export the query to excel and use sum
if. I would like to do this using an access report.
 
Kieran,
In the query behind the report add a "bound" calculated field...
USD : IIF([CurrencyCode] = "USD", [BaseFare], 0)
then sum that column on the report. Do that for each of your CurrencyCodes.
hth
Al Camp
 
Back
Top