I have a sequence of queries, the last of which creates a table for reporting data. When the last query is run, usually by request of some person by his/her Login Id or by an entire Group (In this case, Group Code), I input the information in the criteria of the design grid of a make table query either for Login ID or for Group Code (two separate fields). My question is, if I put "[Enter Login Ids]" or "[Enter Group Codes]", in the criteria section of the query design grid under the Login ID field or Group Code field, am I limited to only one record per search or can I input multiple records by using this expression? Using “Like xxx1234 or like xxx2345” for example, is acceptable from the design grid, can this also be acceptable from a parameter window when the command button is pushed to run the make table query from a form?
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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!