I have a cross tab query that is based on query2 that is based on query1. Query1 filters the data (a very large table) by a date range (with from [starting date] to [ending date]. If I run query1 or query 2, it's fine. But when I run the cross-tab query, I get the error:
'The Microsoft Office Access database engine does not recognize '[Starting Date]' as a valid field name or expression.
Anybody know why I'm getting this error?