Parameter Queries

I have a parameter query, using between and to which works fine, but I
want to enhance the query to do the following.

1) I want to be able to select individual values in my parameter,
instead of a range - for example 1,5,7,20 instead of 1 - 20.

2) If I dont enter any values in the parameter query, I want all the
results to return.

Many Thanks

Alec

You can use Instr() in the parameter. Here is a link to what you need:

http://support.microsoft.com/kb/100131

Bonnie
http://www.dataplus-svc.com

alecgreen wrote:
I have a parameter query, using between and to which works fine, but I
want to enhance the query to do the following.

1) I want to be able to select individual values in my parameter,
instead of a range - for example 1,5,7,20 instead of 1 - 20.

2) If I dont enter any values in the parameter query, I want all the
results to return.

Many Thanks

Alec

--
Message posted via http://www.accessmonster.com

On 17 Jul, 14:17, "bhicks11 via AccessMonster.com" u44327@uwe wrote:
You can use Instr() in the parameter. *Here is a link to what you need:

http://support.microsoft.com/kb/100131

Bonniehttp://www.dataplus-svc.com

alecgreen wrote:
I have a parameter query, using between and to which works fine, but I
want to enhance the query to do the following.

1) I want to be able to select individual values in my parameter,
instead of a range - for example 1,5,7,20 instead of 1 - 20.

2) If I dont enter any values in the parameter query, I want all the
results to return.

Many Thanks

Alec

--
Message posted viahttp://www.accessmonster.com

Thanks! that works perfect

Your welcome!

alecgreen wrote:
You can use Instr() in the parameter. Â*Here is a link to what you need:

[quoted text clipped - 17 lines]
--
Message posted viahttp://www.accessmonster.com

Thanks! that works perfect

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200807/1