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.