manix
Registered User.
- Local time
- Today, 16:12
- Joined
- Nov 29, 2006
- Messages
- 100
Hi All,
I have a complex query that uses the following expression to calculate a rating. However, if one of the ocnditions is not met, it returns a "#error". This is fine, but I want to mask this with something like "No Rating", when they are not met.
Is this possible and how is best to do it? I am not sure if I can fit anymore elses into the expression. Is it best to put it via VB>?
So if none of these conditions are met, you will get #error.
TIA
I have a complex query that uses the following expression to calculate a rating. However, if one of the ocnditions is not met, it returns a "#error". This is fine, but I want to mask this with something like "No Rating", when they are not met.
Is this possible and how is best to do it? I am not sure if I can fit anymore elses into the expression. Is it best to put it via VB>?
Code:
Rating: IIf([qry_vend_rating2_lstQ2]![Total Demerits]<=10,"A",IIf([qry_vend_rating2_lstQ2]![Total Demerits]<=30,"B",IIf([qry_vend_rating2_lstQ2]![Total Demerits]<=50,"C",IIf([qry_vend_rating2_lstQ2]![Total Demerits]>=51,"D","A"))))
So if none of these conditions are met, you will get #error.
TIA