Query
 

Hi All,

I have the following in a query

(T.Loc='101') OR (T.Loc='102') OR (T.Loc='103') OR (T.Loc='104') OR
(T.Loc='105') OR (T.Loc='106') OR (T.Loc='107') etc....

is there a way to reduce this ? like T.Loc=101,102,103,104 etc or any
other way?

Thanks

Query
 

you might try
={101,102}
or
t.loc=101 and t.loc<107

--
Don Guillett
SalesAid Software

"Soniya" wrote in message
oups.com...
Hi All,

I have the following in a query

(T.Loc='101') OR (T.Loc='102') OR (T.Loc='103') OR (T.Loc='104') OR
(T.Loc='105') OR (T.Loc='106') OR (T.Loc='107') etc....

is there a way to reduce this ? like T.Loc=101,102,103,104 etc or any
other way?

Thanks

Query
 

thanks for your reply

={101,102}
does not work and i am not looking for the other option

Query
 

Have you tried the IN operator?

Example: T.Loc IN(101,102,103,104)
(assuming the values are numeric and not text, otherwise enclose each value
in quotes)

Does that help?

Ron


"Soniya" wrote:

Hi All,

I have the following in a query

(T.Loc='101') OR (T.Loc='102') OR (T.Loc='103') OR (T.Loc='104') OR
(T.Loc='105') OR (T.Loc='106') OR (T.Loc='107') etc....

is there a way to reduce this ? like T.Loc=101,102,103,104 etc or any
other way?

Thanks