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



© 2020 - ErnesTech - Privacy