Totals from Subforms According to Yes/No Boxes

[yepwingtim]

Been scratching my head with this one...
How can I get the Total from the SubForm According to the Yes/No Boxes

http://img28.imageshack.us/i/sformi.jpg

The Totals for ID's 1, 2, 3 would be

ID 1 = $2.00
ID 2 = $4.00 + $5.00
ID 3 = $5

TOTAL would be $16.00

Thanks!

Danielle
________
DODGE TOWN PANEL HISTORY

 

[pbaldy]

I'd say the design is flawed, but this type of thing:

IIf(YesNo1, Field1, 0) + IIf(YesNo2, Field2, 0) + IIf(YesNo3, Field3, 0)

 

[yepwingtim]

Thanks pblady!

Design isn't flawed. i just made it alot simplier to understand what I want

Do I have to make another textbox (Total_checked) in the subform if i have to get the totals in the mainform from the subform?

Thanks again
________
Mercedes-Benz W125 Rekordwagen