Sum formula for combo box

HaChIrish

Registered User.
Local time
Yesterday, 23:20
Joined
Oct 11, 2002
Messages
28
I have a report that prints a list of my combo box values and a count in the footer. My combo box is called OPTIONS and has SOLD, DECLINED, PENDING, and QUOTE. How would I calculate the sum total of OPTIONS divided by total SOLD?
 
Not sure if it will work, but in the report footer have a textbox that has for its criteria: =Sum([OPTIONS])/Sum([SOLD])

HTH
 

Users who are viewing this thread

Back
Top Bottom