Calculated Control - Sum one field based on value in another fiel

  • Thread starter Thread starter PAR
  • Start date Start date
P

PAR

I had a calculated control on a report that used this formula:
=Round((DSum("[General Sale Epense]","[Expenses]")-DSum("[Out lot]","[Lot
Info]"))/DSum("[Price]","[Lot info]"),4)

There is a need to change the criteria so the first DSum only totals
"[General Sale Expense]" if the field [Expense Type] has a value of "All
Consignors"

How do I adjust the formula?

Thank you
 
--
Dave Hargis, Microsoft Access MVP

DSum("[General Sale Epense]","[Expenses]","[Expense Type] = ""All
Consignors""")
 
Back
Top