Info from txt box

[Guest]

I have a query that picks up dept name from a text box.
If dept name e.g is dept1, the querry wroks ok.
BUT if my text box says "Dept1" or "dept2", then it does not give the result
for dept 1 OR Dept2.
How do I get the results for more than one dept from the text boX value?

 

[Vincent Johns]

I have a query that picks up dept name from a text box.
If dept name e.g is dept1, the querry wroks ok.
BUT if my text box says "Dept1" or "dept2", then it does not give the result
for dept 1 OR Dept2.
How do I get the results for more than one dept from the text boX value?

By running it twice? ;-)

Seriously, if your database is not designed to do that, you may be
stuck. If you have permission to change the design yourself, you can
change the way the contents of the text box are used. But if you're
using an *.MDE database file, your options are pretty limited.

I assume you are in a position to revise the Query you mentioned. If
so, and if you can post the SQL of that Query on this newsgroup, someone
can probably give you more detailed advice on what you can do with it.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Guest]

Hi

Try this..

select * from table_name where
dept_name = <ENTER UR TEXTBOX NAME>

Thanks

Sunil.T

 

[Guest]

HI,

U CAN TRY THIS ONE ALSO

SELECT TABLENAME.*
FROM TABLENAME
where LCase ( [TABLENAME]![NAME] ) = Lcase ( <ENTER UR TEXTBOX NAME HERE
USING THE EXPRESSION BUILDER>)

THANKS

WITH REGDS

SUNIL.T