Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
crosstab query to display list of a field to select
0 views
Skip to first unread message
Krish
Oct 21, 2004, 10:21:56 AM10/21/04
to
I have a crosstab query with two rows, with criteria to prompt to enter the
name of the department and /or a category within the department. How can I
make a list visible to the user to select for either rows, so that the
selection from the list will be pasted to continue processing the query?
name of the department and /or a category within the department. How can I
make a list visible to the user to select for either rows, so that the
selection from the list will be pasted to continue processing the query?
Thank you all for your valuable guidance.
K
Duane Hookom
Oct 21, 2004, 1:40:02 PM10/21/04
to
You should create a form with a list box or combo box to use as the
criteria. You then must enter the form and control name into the crosstab
query parameters. For instance:
Forms!frmDates!txtStartDate Date/time
criteria. You then must enter the form and control name into the crosstab
query parameters. For instance:
Forms!frmDates!txtStartDate Date/time
--
Duane Hookom
MS Access MVP
"Krish" <Kr...@m-and-m.com> wrote in message
news:eNqquk3...@TK2MSFTNGP09.phx.gbl...
0 new messages