I have a query that filters entries between dates that are entered on a Form called FLegalLanding
the criteria formula I am using is "between [forms]![flegalLanding]![StartDateRng] and [forms]![flegalLanding]![EndDateRng]"
This query works with no problems. I then go through another query and a union to manipulate the data and combine two queries. Again the output of these queries all work just fine.
The only place in all of these queries that have dates or reference to the filtering is the original query
Finally my Union feeds a query that is only there to turn it into a crosstab table.
When I run this crosstab query I get an error
"The Microsoft Access database engine does not recognize '[forms]![flegalLanding]![StartDateRng]'as a valid field name or expression."
If I remove the criteria then the cross tab will work, if I replace that criteria with "between date() and date-120" it works (however this does not really solve my problem because I need to be able to change the dates).
I tried changing it to "between [Enter Start Date] and [Enter End Date] and again all of the forms would work except for the cross tab which through about the same error.
I'm sure I am missing something easy but I have gone through everything I could think of.