ErnesTech | Access Database IF Statement

Question

Accepted Answer

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.