I have a query that selects a date range from a form. The query itself runs fine, however when I attempt to use the query for the basis of a cross tab query it errors out and give me a message " The Microsoft Jet database engine does not recognize'[forms]![frmwork]![start_date] as a valid field name or expression" Are there any ideas why I am getting errored out when the expression works fine in the regular select query?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using a form control for a cross tab query
- Thread starter kkarren
- Start date
Change
[forms]![frmwork]![start_date]
to
Forms![frmwork]![start_date]
-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------
[forms]![frmwork]![start_date]
to
Forms![frmwork]![start_date]
-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question