I have data that is output from a measurement device and I am building reports for the data through access. Currently I have a croostab querry that will provide the data that I need, but I need to allow the user to filter by a specific field to limit the report to one specific part. Normally (with a Select Query) I do this by creating a form with a combo box which will allow the user to choose the part, embed that combo box selection as the criteria in the query and launch the report. The full expression in the criteria is: Like [Forms]![Frm_832_SN]![Input_832_SN] & "*"
Using a croos tab query with this method results in the following error.
The Microsoft Jet database engine does not recognize [Forms]![Frm_832_SN]![Cmb_832_SN] as a valid field name or expression. (Error 3070)
Any help you can provide would be appreciated.
Vinkid![Cool :cool: :cool:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Using a croos tab query with this method results in the following error.
The Microsoft Jet database engine does not recognize [Forms]![Frm_832_SN]![Cmb_832_SN] as a valid field name or expression. (Error 3070)
Any help you can provide would be appreciated.
Vinkid