I am trying to filter dates based on the DateAdd field in my query. It will not allow me to use specific criteria in the query under the DateAdd field. I can filter if I use enter the date in the expression such as Between #04/01/2005# And #05/01/2007# in the DateAdd field. I want to filter the criteria based on the dates I enter in a form. I am using this as my expression.
Between [Forms]![Employee Information]![Start Date] And [Forms]![Employee Information]![End Date]
This expression works fine in all fields execpt the dateadd field