By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,044 Members | 1,291 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,044 IT Pros & Developers. It's quick & easy.

I need to set up a rather liberal Parameter Query

P: 56
I am trying to set up a query that will allow the user to enter just one or maybe three parameters for a specific field.


eg...

query to prompt user for proj#

user wants to pull proj 1 5 and 9 all at once the first time, next time they only want to pull proj 12.

when I tried putting 1 or 5 or 9

I get 0 results

when I tried putting 1, 5, 9

I get 0 results

Is there a way to have it filter all three with out running the query 3 separate times?

The plan is to make this data available to a refreshable spreadsheet, so the user will never actually see the query itself, just the results. I want to be able to have the query pull only the information needed so no filtering is needed in excel.

Is this possible????
Oct 17 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
Yeah,

it's possible using VBA and functions that generate SQL conditions...

But it's hard to do... With very specific construction of your queries to perform this task....

In all cases you need to use VB for delete the query and to recreate it like you want... Other way isn't possible!

Best regards
Oct 21 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.