aafroehlich
New Member
- Joined
- Dec 8, 2005
- Messages
- 15
I have a query that is pulling data from a table. In the table i have a feild name "Num_Errs" and "Tot_Trans" and "Tier".
Tier could have one of 3 values: "Tier 1", "Tier 2" or "Tier 3".
Where Tier 1 = 98% error free Tier 2 = 97% error free and Tier 3 is everything else....
I need to say is give the value in "Num_Errs" if "Num_Errs" / "Tot_Trans is greater then 98% and falls into Tier 1. Else give me zero.
Can someone please help in do this...
Thanks,
Tier could have one of 3 values: "Tier 1", "Tier 2" or "Tier 3".
Where Tier 1 = 98% error free Tier 2 = 97% error free and Tier 3 is everything else....
I need to say is give the value in "Num_Errs" if "Num_Errs" / "Tot_Trans is greater then 98% and falls into Tier 1. Else give me zero.
Can someone please help in do this...
Thanks,