I have a query that executes perfectly in query design mode, SQL:
But, when I try to duplicate the SELECT in code I get "Expected End of Statement". I've turned blue in the face trying to find the issue.Code:SELECT FirstName, LastName, Month([DOB]) AS Mth, Day([DOB]) AS Dy FROM Registry WHERE ((Month([DOB]) = 1) AND (NOT [DOB] Is Null)) ORDER BY Month([DOB]), Day([DOB]);