HELP!!! CRITERIA IN A SELECT QUERY

[JINGRAM]

HI I WAS WONDERING IF THERE IS A LIMIT TO HOW MANY RECORDS THERE ARE ALLOWED IN THE CRITERIA BOX - WE HAVE PROBABLY AROUND A 500 OR MORE AND IT WON'T LET US ENTER ANYMORE - WHAT DO I DO??? PLESE HELP

 

[KyleS]

Over 500 criteria in 1 select query? Wow. Well you could use multiple queries. are you duplicating some?

ie:
Name Date
"Jones" >#12/1/00#
"Smith" >#12/1/00#
&quot;Smith&quot; <#12/31/00#

Could be
&quot;Jones&quot; >#12/1/00#
&quot;Smith&quot; Between #12/1/00# AND #12/31/00#
Kyle :

 

[JINGRAM]

Well there probably isn't 500 records but close to it -
What they are is Part Numbers from an internal database - we don't have many consecutive numbers so...... is there anyway of increasing the limit of characters in the criteria? I am going to try to use the Part numbers (between - and) and see if I can decrease the amount of part numbers in that area- thanks for the input - how would I tie in more than one query if I am using so much criteria?
thanks jen

 

[raskew]

An easier method may be to add field Selected (Yes/No) to your table then, using a lookup form, select the specific records.

In your query, include the Selected field, with criteria: True. This will return the records you picked, without having to rewrite the query each time the requirement changes.

 

[james33]

Dear JINGRAM,

Is there absolutely no commonality in the part numbers or is there any other property(ies) of the parts which you will be looking for(i.e. What they fit on etc) which could allow you to define them in a broader way?

Why are you looking for them, are they from a common supplier?
Do they perform a specific function, in which case a separate field may help in the underlying table!
HTH
Regards Jim