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

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
 
K

Klatuu

--
Dave Hargis, Microsoft Access MVP

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dsum and Dmax with structured references 1
Sum [Price] IIF [BelowSetFloor] >0 1
calculated value 11
total Amt Due, Taxes, Shipping, Expense and Total Amt Due on Invoi 2
showing just the latest value in a text box 3
report based on select query 1
Errors in Report total fields 19
Formatting Rule: Diplay Section based on Selection in another section 0

Top