Multi expression in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use val([regular])+val([regular1]) or cint([regular])+cint([regular1]). These
fields are text you can convert it either way.

HTH
Martin J
 
Back
Top