Syntax error(Comma) in query expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,
What does this error mean "Syntax error (comma) in query expression
'[tbl_PM's].[DateAdd("m",[Month],[Scheduled_Date])]'?

Thanks
Anna
 
Anna said:
What does this error mean "Syntax error (comma) in query expression
'[tbl_PM's].[DateAdd("m",[Month],[Scheduled_Date])]'?
Click to expand...


The [tbl_PM's] part of that is either extraneous or out of
place. That then caused an extra set of [ ] around the
DateAdd Function call. so who knows where the query parser
goes with all that?

Maybe all you want for that is:

DateAdd("m",[Month],[Scheduled_Date])
 
I made that expression in query and I want to connect the results to the tbl
but it's not working.

Marshall Barton said:
Anna said:
What does this error mean "Syntax error (comma) in query expression
'[tbl_PM's].[DateAdd("m",[Month],[Scheduled_Date])]'?
Click to expand...


The [tbl_PM's] part of that is either extraneous or out of
place. That then caused an extra set of [ ] around the
DateAdd Function call. so who knows where the query parser
goes with all that?

Maybe all you want for that is:

DateAdd("m",[Month],[Scheduled_Date])
Click to expand...
 
What do you think "connect the results to the tbl" means?
It isn't part of the usual terminology associated with this
kind of question so I don't know where to go with your
question.
--
Marsh
MVP [MS Access]

I made that expression in query and I want to connect the results to the tbl
but it's not working.

Marshall Barton said:
Anna said:
What does this error mean "Syntax error (comma) in query expression
'[tbl_PM's].[DateAdd("m",[Month],[Scheduled_Date])]'?
Click to expand...


The [tbl_PM's] part of that is either extraneous or out of
place. That then caused an extra set of [ ] around the
DateAdd Function call. so who knows where the query parser
goes with all that?

Maybe all you want for that is:

DateAdd("m",[Month],[Scheduled_Date])
Click to expand...
Click to expand...
 
Back
Top