Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
HELP!!! CRITERIA IN A SELECT QUERY
- Thread starter JINGRAM
- Start date
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#
"Smith" <#12/31/00#
Could be
"Jones" >#12/1/00#
"Smith" Between #12/1/00# AND #12/31/00#
Kyle :
ie:
Name Date
"Jones" >#12/1/00#
"Smith" >#12/1/00#
"Smith" <#12/31/00#
Could be
"Jones" >#12/1/00#
"Smith" Between #12/1/00# AND #12/31/00#
Kyle :
- Thread starter
- #3
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
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
Programmer
- Oct 18, 2000
- 488
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.
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.
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
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
- Status
Similar threads
- Locked
- Question