Ernes
Tech
Register
Login
Jobs
Search
News
Articles
Videos
Shop
Home
Articles
Details
+1 (216)-435-0788
Join the Community
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
Views:
318
76
Notify Me of New Posts
×
We Recieved Your Request. Thank you.
We'll never share your email with anyone else.
Submit
You Liked This Article
No Login Required!
If you log in, you will be notified when someone leaves a comment.
Other users would like to know if this solution helped you.
Post Comment
Login With Google
Login With LinkedIn
Login With Microsoft
Login With GitHub
Top
© 2023 - ErnesTech LLC-
Privacy
+1 (216)-435-0788
English (United States)
Spanish (Spain)
French (France)
Portuguese (Brazil)
Chinese (China)
Turkish (Turkey)
German (Germany)
Jobs
Search
News
Articles
Videos
Shop
Contact
Sign Up
Login
Grid-Method Tools
PDF to HTML Converter
Forums
How Can We Improve this Site?
2 + 4 =
Submit