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

Syntax error (comma) in query expression

P: 1
I am creating a Query in design view and I am try to create a calculated field with an IIf conditional Logic.


The fields YearsService and Salary is part of my query.

Is a very simple query but it does not run.
Mar 23 '17 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,430
You might try

Expand|Select|Wrap|Line Numbers
  1. Increase:IIf(Nz([YearsService]) > 9, [Salary]*0.03, [Salary]*0.02)
Could be getting a null YearsService

Mar 23 '17 #2

Post your reply

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