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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

multiple selection TEXT box entry for query?

Status
Not open for further replies.

keiserc

Technical User
Feb 24, 2004
16
US
I have a command button that runs a query that runs a report. I have set up the query as a param query - [enter job#] and it will run the report on 1 job#.

How do you set it up so you can enter -in a pop up TEXT box - more than 1 job#? All I find help on is selecting from a list box...

I've set up queries for multiple criteria [enter year]AND [enter other variable].

I've set up queries for [enter criteria] OR [enter criteria] as long as the 2 critera are DIFFERENT fields.

how do you enter multi selections for the same field?
[job#1] AND [job#2] AND [job#3]???
 
You can try parsing the string entered in the text box for the numbers and use it in your query.

-Laughter works miracles.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top