Access Database IF Statement

  Funny story, so when I was working on a division by 0 error in Access Database and needed toimplement an
  IF Statement to eradicate the error. It was until a while that I found out the IF Statement syntax in Access SQL is different from 
  T-SQL. The correct IF Statement in Access SQL is IIF(file=0, then value, else thisValue) in short its: IIF(,,) that is it.

Edit this Article
Was this page helpful?
Yes Yes! this solution to the problem was helpful. No No! this solution to the problem was not helpful.. Leave ErnesTech Feedback.Feedback
If you log in, you will be notified when someone leaves a comment.

Other users would like to know if this solution helped you.

Your Session is Ending
Login to Continue

© 2021 - ErnesTech - Privacy