Syntax error(Comma) in query expression

[Guest]

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

Thanks
Anna

 

[Marshall Barton]

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

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

 

[Guest]

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

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

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

 

[Marshall Barton]

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.

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

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