Help with Query

[Paul M]

Hi
I need to add a search criteria to a field but I am already searching that
field
The field is Project_ID and at the moment it only returns results on ID's
with a value greater than 1.
But I also wish to be able to search the ID by putting the ID number in
directly in the search for people who know the project number
Would this work

And Project_ID >=1 AND Project_ID = :roject_ID::


Thanks Paul M

 

[Kathleen Anderson [MVP - FrontPage]]

Try Project_ID >=1 OR Project_ID = :roject_ID::

 

[Paul M]

Thanks Kathleen
Paul M

Try Project_ID >=1 OR Project_ID = :roject_ID::


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/