calculated dates and date ranges....

[CFP - Jason]

how do i run a query on a date range that is a calculated date that is not stored but calculated in the form. i have a field that calcs the next scheduled date and want a to run a query that shows the calculated dates that fall in that range. thanks
Jason

 

[dcx693]

You can refer to a field on your form from the query. In the criteria line below the field in your query, enter an expression like this:
Forms!formname!fieldname

You can use the standard Like, Between And, Or, etc... operators with that reference.

 

[CFP - Jason]

its says undefined function "adddate" in expression.
Jason

 

[dcx693]

Never heard of the adddate function, but I have used the DateAdd function.