In SQL statements, all databases use quotes to delimit strings but different databases use different delimiters for dates. This is one of the most common problems when trying to port database code from Access to SQL Server or vice versa but at least it's easy to fix once you understand what the problem is.

• SQL Server uses quotes (') as in '4/1/2010'
• Access (Jet) uses number signs (#) as in #4/1/2010#