Multi expression in query

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
 
G

Guest

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

HTH
Martin J
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare results of two expressions within query 1
IIf Statement Error 3
multiple expression in Queries 4
data type mismatch in criteria expression 2
Calculated field identifiers used in another calculated field 3
Access Query problem 1
Date expression in Query 4
Cumulative counts in a query 2

Top