By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,730 Members | 1,500 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,730 IT Pros & Developers. It's quick & easy.

IIF Command in Update Query - not working

P: 2
I want to update a field like 'Division' in Marks table. I want to set 'Division' field values compering'Percentage' field.
I cannot update Division field using the following update query.
Expand|Select|Wrap|Line Numbers
  1. IIf([Marks]![Percentage]>60,"First",IIf([Marks]![Percentage]>50,"Second",IIf([Marks]![Percentage]>40,"Third","Fail")))
Please help me thanks.
4 Weeks Ago #1
Share this Question
Share on Google+
1 Reply

P: 2
The Percentage field was Text type and number type. Now the problem solved.
4 Weeks Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.