Help with Parameters ...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

testtech2522 - 23 Feb 2006 19:41 GMT

I am setting up an access 2003 database at work. In one of my queries I need
100 parameters EX: ([product id#1] Or [product id#2] Or [product
id#3]............. ) However with this expression if I only need to enter 20
product ids I will need to press enter 80 times to view my report. If I must
I will create 10 different queries each one with a different number of
parameters. Is that the only to solve this problem? I hope not

Thank-You
testtech2522

Reply to this Message

Jonathan West - 23 Feb 2006 20:06 GMT

Hi testtech2522

The group you have posted to deals with VBA in Word, not access. If you want
Access experts to see your question, I would recommend that you repost to
one of the microsoft.public.access groups.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

>I am setting up an access 2003 database at work. In one of my queries I
>need
[quoted text clipped - 8 lines]
> Thank-You
> testtech2522

Reply to this Message