If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Parameter Queries
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 |
#3
|
|||
|
|||
Parameter Queries
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 |
#4
|
|||
|
|||
Parameter Queries
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 |
Thread Tools | |
Display Modes | |
|
|