If statement with within query

[masalachol]

I am trying to do the following in a query without success. Any suggestions


If ParseOne+ParseTwo-Imp3=-0.01
then
0.01+ParseTwo
Else
ParseTwo

OR

If ParseOne+ParseTwo-Imp3=0.01
then
ParseTwo-0.01
Else
ParseTwo



P2: IIf(([ParseOne]+[ParseTwo])-([Imp3])="-0.01",0.01+[ParseTwo],[ParseTwo]) & IIf(([ParseOne]+[ParseTwo])-([Imp3])="0.01",[ParseTwo]-0.01,[ParseTwo])

Instead of getting one value in the query field .... I am getting both values ie P2
5.485.47..... it should either be 5.48 or 5.47

-

 

[PHV]

Have you tried this ?
P2: IIf(ParseOne+ParseTwo-Imp3=-0.01,0.01+ParseTwo,IIf(ParseOne+ParseTwo-Imp3=0.01,ParseTwo-0.01,ParseTwo))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Golom]

The code you have is concatenating two strings generated by the two IIF statements. I think that you really want the results from only one of the IIF statements. Try this

P2: 
IIf(([ParseOne]+[ParseTwo])-([Imp3])=-0.01,",[ParseTwo]+0.01,
IIf(([ParseOne]+[ParseTwo])-([Imp3])=0.01,[ParseTwo]-0.01,[ParseTwo])

I'm assuming that "[ParseOne]", "[ParseTwo]" AND "[Imp3]" are all numeric fields.

 

[masalachol]

Golom and PHV .... YOU ARE AWSOME, THANKS!!!