505.369.1650 [email protected]

Here are some differences in how SQL is written in Microsoft SQL Server versus Microsoft Access.

  • Update query syntax is different.
  • Use + instead of & in queries.
  • Use ‘ around a date instead of #.
  • Use GetDate() instead of Date().
  • Use CASE x THEN y ELSE z END instead of IIF(x,y,z).

Making Microsoft Access Work

No matter what your MS Access needs are, Carl can provide live help to make sure you get the solution you need.