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.


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

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

Your Session is Ending
Login to Continue


© 2021 - ErnesTech - Privacy