I would create a table with one field where I will enter all the number I
wont to have the resault for
Then in the query add the criteria
Select * From YourTableName Where FieldName In (Select FieldName From
NewTableName) Or FieldName between "1500" and "7800"
That way, if you need to add numbers or remove numbers, all you need is to
add or delete to or from the table, without touching the query.
Also, if you developing the system for someone, you can create a form where
he can enter the values without beeing dependend on you.
==================
One question, in the between criteria that you gave you had quote between
the numbers which indicates on string type field, if that the case, to make
the between work properly convert the text to number
Select * From YourTableName Where FieldName In (Select FieldName From
NewTableName) Or CLng(FieldName) between 1500 and 7800
--
Good Luck
BS"D
"annder" wrote:
> I need to know how to query for many diffent numbers
> (like 30 random numbers) in my ticket # field
> not using- between "1500" and "7800" (in criteria line)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12081
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12081
> also
> and not using criteria line: 1500
> then using the next line or: 1900
> then the next line : 2000
> and soforth
> this is actully almost what i need but it only lets me enter 9 different
> numbers i need to be able to use and unlimited number
> 
Our Donation Goal
: Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters 
Linear Mode
