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

My usage of the iif function in MS Access seems to leave much to be desired, can anyo

P: 2
My IIf expression in query field reads:
UD: iif([field2]<6,"D","I")
field2 is a calculation field. The response I get is "The expression you entered contains invalid syntax. You may have entered an operand without an operator". Help!!
Mar 15 '19 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 2.5K+
P: 3,283

Welcome to Bytes!

Please copy and paste the entire query so that we can see everything involved with this issue.

Mar 15 '19 #2

P: 2
The query is exactly as described. More - you will know it is an MS Access Query wherein I want to use IIF to draw info from another "field2" and the question asked is if the info drawn is <6 the true answer should be "D" if not "I". This might be superfluous info as you in all probability would see it in the expression given. Maybe I should use another function to get a better result? Maybe this IIF is for text only and not to check on a number? The expression should be correct but perhaps not correctly used?
Mar 15 '19 #3

Expert Mod 2.5K+
P: 3,283
We have no doubt that the query is exactly as described. This is why we would like to see the entire query, so we can examine it. Just copy and paste it here so we can see it.
Mar 17 '19 #4

Post your reply

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