Solved Assign Dummy Value in Query

[mfaisal.ce]

Dears,

i want to make a query with a criteria based on value of Field....

Table: Purchase
Field. ID
Field. Balance

I want to make a query in such a way that
1. Balance =0, output 0
2. Balance >0,output 1
3.Balance <0, output 2

Kindly guide....

 

[plog]

You want an iff statement:

MS Access: iif Function

This MSAccess tutorial explains how to use the Access iif function with syntax and examples. The Microsoft Access iif function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE.

www.techonthenet.com

CustomField: IFF(Balance>0,1, IFF(Balance<0,2,0))

 

[mfaisal.ce]

This is not possible in Query statement??

 

[arnelgp]

select ID, Balance, Switch([Balance] = 0, 1, [Balance] > 0, 1, [Balance] < 0, 2, True, Null) As Output From [Purchase]

 

[mfaisal.ce]

thanks a lot....

 

[Isaac]

You want an iff statement:

MS Access: iif Function

This MSAccess tutorial explains how to use the Access iif function with syntax and examples. The Microsoft Access iif function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE.

www.techonthenet.com

CustomField: IFF(Balance>0,1, IFF(Balance<0,2,0))

IIF