Missing Operator In Query Expression

[Chucky]

I have been going crazy slowly all week. When I step through my code I
get Run Time Error 3075, Syntax error, Missing Operator in Query
Expression. I think that I have narrowed the error down to the next to
last line of the following code, where the function MonthNumber is
used. The fields that start with 'Choose' are fields on a form.
StudentIDData is a variant. Can anybody help???? Please

StrSQL = " SELECT tblStudentMaster.[Last Name] AS LastName,
tblStudentMaster.[First name] AS FirstName, tblStudentMaster.StudentID,
tblStudentMaster.status, tblStudentMaster.Month,
tblStudentMaster.[Start Date] AS StartDate, tblStudentMaster.YearX,
tblStudentMaster.Month, MonthNumber([Month]) AS MonthNbr, *" _
& " FROM tblStudentMaster" _
& " WHERE (((tblStudentMaster.StudentID) = " & StudentIDData & ")" _
& " And ((tblStudentMaster.Month) = """ & Me![ChooseMonth] & """)" _
& " And ((tblStudentMaster.YearX) = """ & Me![ChooseYear] & """))" _
& " Or (((tblStudentMaster.StudentID) = " & StudentIDData & ")" _
& " And ((tblStudentMaster.YearX) > """ & Me![ChooseYear] & """))" _
& " Or (((tblStudentMaster.StudentID) = " & StudentIDData & ")" _
& " And ((tblStudentMaster.YearX) = """ & Me![ChooseYear] & """)" _
& " And ((MonthNumber(tblStudentMaster.[Month])) > " & "MonthNumber("""
& Me![ChooseMonth] & """)))" _
& " ORDER BY tblStudentMaster.YearX, MonthNumber([Month]);"

[Jana]

Chucky:

One quick question:
Is MonthNumber a custom function you have in your db? Does it do
anything different than the built in Month function?

Jana

[Chucky]

Jana,

MonthNumber returns a number when the argument is the MonthName. I
created it and it resides in a module

Chuck

[Chucky]

Jana,

MonthNumber returns a number when the argument is the MonthName. I
created it and it resides in a module

Chuck

[ADezii]

Is MonthNumber(<MonthName>) a Public Function?

[Bob Quintal]

"Chucky" <cb******@optonline.net> wrote in
news:11**********************@i39g2000cwa.googlegr oups.com:

I have been going crazy slowly all week. When I step through
my code I get Run Time Error 3075, Syntax error, Missing
Operator in Query Expression. I think that I have narrowed the
error down to the next to last line of the following code,
where the function MonthNumber is used. The fields that start
with 'Choose' are fields on a form. StudentIDData is a
variant. Can anybody help???? Please

& " And ((MonthNumber(tblStudentMaster.[Month])) > " & "MonthNumber
(""" & Me![ChooseMonth] & """)))" _

has excessive parentheses and some superfluous quotes. You are also
missing an underscore at the end of the upper line.
& " And MonthNumber(tblStudentMaster.[Month]) " _
& " > MonthNumber(""" & Me![ChooseMonth] & """) " _

--
Bob Quintal

PA is y I've altered my email address.

[Chucky]

Thanks Bob, It works Fine Now !!!!!

[Bob Quintal]

"Chucky" <cb******@optonline.net> wrote in
news:11**********************@g10g2000cwb.googlegr oups.com:

Thanks Bob, It works Fine Now !!!!!

It makes me happy to hear that.
--
Bob Quintal

PA is y I've altered my email address.