Syntax error

[GraeagleBill]

I have a query that executes perfectly in query design mode, SQL:

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]);

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.

[isladogs]

You need to put " & _ at the end of each line instead of " _

[GraeagleBill]

Of course, I know that! Not been one of my better days.
Thanks Colin,
Bill

[Micron]

or & at the beginning of the next?

& " FROM ...