Tow or more options in query

[Guest]

Hi!

In query I have
Like [Cod or * for all]
in cod column.

I would like to be able to choose two or three Cod.
Thanks in advance.
an

 

[Ken Snell \(MVP\)]

Sounds as if you want the ability to specify multiple strings to be found.
This cannot be done directly in a query, but instead will require the use of
a form where the user can select / enter the various choices and then the
form builds the desired SQL statement for the query. See this sample
database for some example programming on how to do this with a listbox (for
selecting multiple items):
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

 

[Guest]

KS,
thanks for reply.

I thought that for the same field in same query it could make more than what
one asks.

an

Sounds as if you want the ability to specify multiple strings to be found.
This cannot be done directly in a query, but instead will require the use of
a form where the user can select / enter the various choices and then the
form builds the desired SQL statement for the query. See this sample
database for some example programming on how to do this with a listbox (for
selecting multiple items):
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

--

Ken Snell
<MS ACCESS MVP>

Hi!

In query I have
Like [Cod or * for all]
in cod column.

I would like to be able to choose two or three Cod.
Thanks in advance.
an

 

[Guest]

Sorry.
Can you indicate me another site with sample to Access 2k, please.
an

Sounds as if you want the ability to specify multiple strings to be found.
This cannot be done directly in a query, but instead will require the use of
a form where the user can select / enter the various choices and then the
form builds the desired SQL statement for the query. See this sample
database for some example programming on how to do this with a listbox (for
selecting multiple items):
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

--

Ken Snell
<MS ACCESS MVP>

Hi!

In query I have
Like [Cod or * for all]
in cod column.

I would like to be able to choose two or three Cod.
Thanks in advance.
an

 

[Ken Snell \(MVP\)]

There are different database files there for the three different ACCESS
versions. This is the database for 2000:
http://www.cadellsoftware.org/DownloadFiles/FilterForm_2000.zip

--

Ken Snell
<MS ACCESS MVP>

Sorry.
Can you indicate me another site with sample to Access 2k, please.
an

Sounds as if you want the ability to specify multiple strings to be
found.
This cannot be done directly in a query, but instead will require the use
of
a form where the user can select / enter the various choices and then the
form builds the desired SQL statement for the query. See this sample
database for some example programming on how to do this with a listbox
(for
selecting multiple items):
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

--

Ken Snell
<MS ACCESS MVP>

Hi!

In query I have
Like [Cod or * for all]
in cod column.

I would like to be able to choose two or three Cod.
Thanks in advance.
an

 

[Guest]

Thank you very much.
an

There are different database files there for the three different ACCESS
versions. This is the database for 2000:
http://www.cadellsoftware.org/DownloadFiles/FilterForm_2000.zip

--

Ken Snell
<MS ACCESS MVP>

Sorry.
Can you indicate me another site with sample to Access 2k, please.
an

Sounds as if you want the ability to specify multiple strings to be
found.
This cannot be done directly in a query, but instead will require the use
of
a form where the user can select / enter the various choices and then the
form builds the desired SQL statement for the query. See this sample
database for some example programming on how to do this with a listbox
(for
selecting multiple items):
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

--

Ken Snell
<MS ACCESS MVP>



Hi!

In query I have
Like [Cod or * for all]
in cod column.

I would like to be able to choose two or three Cod.
Thanks in advance.
an