RE: Multi expression in query
From: Martin J (anonmous_at_nospam.com)
Date: 12/30/04
- Previous message: Martin J: "RE: how to make IIf statement result show null value"
- In reply to: Michele: "Multi expression in query"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 30 Dec 2004 12:39:03 -0800
Use val([regular])+val([regular1]) or cint([regular])+cint([regular1]). These
fields are text you can convert it either way.
HTH
Martin J
"Michele" wrote:
> 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
- Previous message: Martin J: "RE: how to make IIf statement result show null value"
- In reply to: Michele: "Multi expression in query"
- Messages sorted by: [ date ] [ thread ]
