DATES
When using MS Access put a # before and after the date
Example: WHERE dateassigned=#7/7/2000#
When using SQL Server put a ' before and after the date
Example: WHERE dateassigned='7/7/2000'