(Q) I am working with generating queries directly from SQL, but
I am having some problems (incorrect syntax) with the date section of my SQL.
(A) It's important to remember that regardless of where you are
using Access, if doing SQL from code you need your dates to be in US format dates eg:
" WHERE DateField >= #" & Format$(startDate, "mm/dd/yyyy") & "#"