mfaisal.ce
Member
- Local time
- Today, 11:23
- Joined
- Dec 21, 2020
- Messages
- 76
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....
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....