Query Question

[AcceSs-AbLe]

Hi,

I am trying to run this query, the first set of If statements produce a result, however the second set of if statements appear to be doing nothing.

CREDIT: IIf([URVALUE]>0,IIf([Account]=5303020001,"C",IIf([Account]=1003050000,"D",IIf([URVALUE]<0,IIf([Account]=1003050000,"C",IIf([Account]=5303020002,"D"))))))

**It works fine until it goes to [URVALUE]<0

How can I amend the query so that all the statements would work.

Thank you!

 

[bat17]

I am not totaly sure but it looks as if there is no false part to [URVALUE]<0 So if [URVALUE] = 0 then nothing will happen.
you could try [URVALUE]<=0 and see if that works or you may need to trap the 0 value seperatlely.

HTh

Peter

 

[AcceSs-AbLe]

Thanks for the reply Peter. I tried <= and it still produces the same results, no change.!

 

[bat17]

I assume that you mean it is returning a blank. I would try breaking it down further just to test what is actualy happening then build it back up instages

CREDIT: IIf([URVALUE]>0,IIf([Account]=5303020001,"C",IIf([Account]=1003050000,"D",IIf([URVALUE]<0,"C","D"))))

HTH

Peter

 

[AcceSs-AbLe]

I used the statement you provided and it produces results for all outputs >0, however, it i see blanks for anything <0 , would it be possible to use two different columns and then combine the results somehow?

 

[bat17]

If you do it in two columns Credit1, Credit2 then you could combine them in a third with Credit:[Credit1] & [Credit2]

HTH

Peter

 

[AcceSs-AbLe]

Thanks Peter, this worked out perfectly. one more question, I have two queries that produce different results, I want to combine both queries and have a third query produce results of both queries. Is this possible?

 

[bat17]

if they both have the same fields the you can use a Union Query.

Look it up in help

Peter