Help with Parameters ...

T

testtech2522

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
 
J

Jonathan West

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.

--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Help with expressions and parameters access 2003 2
VBA word change keys 0
help parameters access 2003 5
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Comparing two lists in Excel 1
200KB versus 35MB 0
Parameter Query in Microsoft office 2007 1

Top