List Box Criteria

[Ant]

I have an unbound list box with the multi Select properties set to ‘Extended’.
One of the fields in the list box is a unique Number field [Group_ID]. I
would like to create a query that is based on the lines selected in the list
box. E.g. If Group ID 2, 5 & 6 are selected then the query will show 2, 5 &
6. Can any one help with the syntax of what I need to enter on the criteria
line of the query?



Thanks

 

[Ken Snell \(MVP\)]

I have a sample database that shows how you can create SQL queries for use
in reports by using the values in various controls on a form. You can look
at that to see how to create SQL queries.

Take a look at the database and then post back with questions:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

 

[Tom Ellison]

Nepotism?

Tom Ellison

Very Useful

Cheers
Tony Snell

I have a sample database that shows how you can create SQL queries for use
in reports by using the values in various controls on a form. You can
look
at that to see how to create SQL queries.

Take a look at the database and then post back with questions:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

--

Ken Snell
<MS ACCESS MVP>

I have an unbound list box with the multi Select properties set to
'Extended'. One of the fields in the list box is a unique Number field
[Group_ID]. I would like to create a query that is based on the lines
selected in the list box. E.g. If Group ID 2, 5 & 6 are selected then
the query will show 2, 5 & 6. Can any one help with the syntax of what I
need to enter on the criteria line of the query?



Thanks

 

[Ant]

Very Useful

Cheers
Tony Snell

I have a sample database that shows how you can create SQL queries for use
in reports by using the values in various controls on a form. You can look
at that to see how to create SQL queries.

Take a look at the database and then post back with questions:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

--

Ken Snell
<MS ACCESS MVP>

I have an unbound list box with the multi Select properties set to
'Extended'. One of the fields in the list box is a unique Number field
[Group_ID]. I would like to create a query that is based on the lines
selected in the list box. E.g. If Group ID 2, 5 & 6 are selected then the
query will show 2, 5 & 6. Can any one help with the syntax of what I need
to enter on the criteria line of the query?



Thanks

 

[Ken Snell \(MVP\)]

Nope! < grin >

--

Ken Snell
<MS ACCESS MVP>

Nepotism?

Tom Ellison

Very Useful

Cheers
Tony Snell

I have a sample database that shows how you can create SQL queries for
use
in reports by using the values in various controls on a form. You can
look
at that to see how to create SQL queries.

Take a look at the database and then post back with questions:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

--

Ken Snell
<MS ACCESS MVP>

I have an unbound list box with the multi Select properties set to
'Extended'. One of the fields in the list box is a unique Number field
[Group_ID]. I would like to create a query that is based on the lines
selected in the list box. E.g. If Group ID 2, 5 & 6 are selected then
the query will show 2, 5 & 6. Can any one help with the syntax of what
I need to enter on the criteria line of the query?



Thanks