View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Multiple parameters in MS Query

Hi!
I created a Microsoft query in Excel to pull some data from our accounting
database. I use [Enter Job Number] as the parameter, so it will ask me to
enter one job number every time I run it. Instead of one job number, how can
make the query to prompt me to enter multiple parameters/job numbers? I know
I can use "Add Criteria" in "Edit" mode to enter more parameters. However,
it is not quite convenient.

Thank you very much!