By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 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.

Increase:IIf([YearsService]>9,[Salary]*0.03,[Salary]*0.02)

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


PhilOfWalton
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)
  2.  
Could be getting a null YearsService

Phil
Mar 23 '17 #2

Post your reply

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