Querying more than 1 selection criteria in a group

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chris M - 21 May 2008 19:35 GMT

This is a repost, unfortunately I posed this question about an hour ago and
it still wasn't listed, so here it goes again. I am trying to do this in a
QBE query screen. I have a field in my table called "FORM LETTER". The
results/data elements in this field are A thru L. In the QBE screen, I want
to put in the
criteria row(S) a select(ion) statement that allows for letters a thru d as
one group, OR j, K, and L for another group, and/or G,H, and I for a third
group. I want to be able to select just one group at a time. If i put in a
"j" or "K" or "L" it works fine, but I want the choice to select the group
in a dialog box so as to not have to design a multidude of reports/queries.
Thank you, chris

Reply to this Message

Jerry Whittle - 21 May 2008 20:43 GMT

The best way to do this is to create an new table called something like
ResultGroups. This table would have at least two columns: FORM_LETTER_ID (the
primary key) with a letter A, B, C, etc., in each record and another Groups
field with the matching 1, 2, 3, 4 in it. Add this table to the query and
then have the Group as the criteria in a parameter query.

Using a fancy self-join, someone could even put in A at the parameter and
get the entire group without knowing at A is in Group 1.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> This is a repost, unfortunately I posed this question about an hour ago and
> it still wasn't listed, so here it goes again. I am trying to do this in a
[quoted text clipped - 7 lines]
> in a dialog box so as to not have to design a multidude of reports/queries.
> Thank you, chris

Reply to this Message