TickBox & calculation help please!

[gjoneshtfc]

Hello

I have a form set up where there is a: number of weeks field, cost per
week field, exam tick box, exam cost field and total cost field. What i
need is for the total cost field to calculate as follows:

if(ExamTick = yes) => Total cost = (Number of weeks * Cost per week) +
Exam Cost

if(ExamTick = no) => Total cost = Number of weeks * Cost per week

Can anyone advise me on how to program the Control Source data entry
for the total cost field to achieve this?? Or if it is possible at
all?! If it is not possible has anyone got any suggestions?

Thanks and kind regards,
Gareth Jones

 

[Al Camp]

Set the ControlSource of a calculated text control to...

= IIF(ExamTick = Yes, (NumberOfWeeks * CostPerWeek) +1, (NumberOfWeeks *
CostPerWeek))
-
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[gjoneshtfc]

Thanks Al!

Worked a treat - cheers!

Regards, Gareth