1 - Idea1: I am doing a crosstab qry. The following works in all my other type of qry but not this crosstab.
I have below in the 1st Qry that collects the data. It works fine and collects the proper REPID.
[forms]![frm8100Finance]![cboRepID]
In the 2nd Qry, the crosstab, I include the REPID as a row heading.
It bombs out saying:
MS database engine does not recognize '[forms]![frm8100Finance]![cboRepID]' as a valid field name or expression.
2 - Idea2: So I went back to Qry1 and instead tried using a criteria of [enter RepID].
But the Qry2 crosstab still barked the same bad answer.
3 - Idea3: Instead, I hardcoded 36 onto the Qry1 RepID criteria row.
The Qry2 crosstab works fine. It accepted the hardcoded 36.
4 - How could I get the idea#1 to work using the [forms]![frm8100Finance]![cboRepID] ??
Maybe I need a formatting deal so that Qry2 recognizes it as a number answer?
thank you. Glen