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.



Write an Article
If you log in, you will be notified when someone leaves a comment.

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


© 2022 - ErnesTech - Privacy