Use a date from a form as criteria against a calculated field

[vjboaz]

I am trying to retrieve records that have an End Date - which is calculated: EndDate: DateAdd("m",[Duration],[Start_Date]) with the criterion of <[Forms]![frmRequest]![Proposed_Start_Date].

I get the error message:

"The expression is typed incorrectly, or is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."

SELECT ActiveTeamRoster.ID, [Last Name] & ", " & [First Name] AS Resource, ActiveTeamRoster.Role, DateAdd("m",[Duration],[Start_Date]) AS EndDate
FROM Assignment INNER JOIN ActiveTeamRoster ON Assignment.ID = ActiveTeamRoster.ID
WHERE (((DateAdd("m",[Duration],[Start_Date]))<[Forms]![frmRequest]![Proposed_Start_Date]));

Can someone please help me?



veejay

[orange]

Is the form open when you tried to run this?
How is Duration dimmed/defined?
Please show your table definitions.

[vjboaz]

The form is open when I try to run it.
Duration is defined as Number - Long Integer.

Thanks!

veejay

[June7]

What are the ID fields? If they are both autonumber, should not be joining on two autonumber fields.