using IF in a report or query

[56th Rowallan]

Hi I need help, badly

I have a report & query which needs a calculation performing if another field is set to "true" and cannot seem to get it to work.

EG total cost:= if [3rd party accedent]="true",([paint cost]+([labour rate]*[hours])+[parts cost]).

Please help I'm a newbie and I bet i've done something stupid

Thanks

Row

 

[boblarson]

You need a part if it is false:
EG total cost:= if [3rd party accedent]="true",([paint cost]+([labour rate]*[hours])+[parts cost], PUT WHAT TO RETURN IF FALSE HERE)

 

[pbaldy]

In a query:

EGTotalCost: IIf([3rd party accedent]="true",([paint cost]+([labour rate]*[hours])+[parts cost]),0)

If that field is actually a yes/no field, drop the quotes around true.

 

[56th Rowallan]

using if

Thank you very much, i jusy could not work it out