Multi expression in query

M

Michele

I have added 2 new fields with expression as follows

Regular:IIf[Expr1]>40,"40",[Expr1]
Regular2:IIf[Expr2]>40,"40",[Expr2]

I added another expression as follows

TotalReg:[Regular]+[Regular2]

In one of the answer it put 4040
When it should be 80
40+40=80
thanks
 
M

Martin J

Use val([regular])+val([regular1]) or cint([regular])+cint([regular1]). These
fields are text you can convert it either way.

HTH
Martin J
 
Top