hrdpgajjar
Registered User.
- Local time
- Today, 07:36
- Joined
- Sep 24, 2019
- Messages
- 92
Hi all,
I have table name Application which consists of following columns,
1. WO Date
2. TPA Date
3. TR Date
4. Invoice Date
5. Current Stage
Now i want to use Case statement to get Current Stage value based on all above 4 columns,
For Example,
If Invoice Date is null and all above 3 fields have dates entered then current stage is "TR DONE"
if invoice Date and TR Date fields are null and rest of above 2 fields have dates then current stage is "TPA Done" so on...
I have tried to enter query in "Onload " of form but not able to do it.
how can i do this?
thanks
I have table name Application which consists of following columns,
1. WO Date
2. TPA Date
3. TR Date
4. Invoice Date
5. Current Stage
Now i want to use Case statement to get Current Stage value based on all above 4 columns,
For Example,
If Invoice Date is null and all above 3 fields have dates entered then current stage is "TR DONE"
if invoice Date and TR Date fields are null and rest of above 2 fields have dates then current stage is "TPA Done" so on...
I have tried to enter query in "Onload " of form but not able to do it.
how can i do this?
thanks