Multiple parameters collected in a query

[Joe Heiser]

Hi all,

I am trying to develop a pretty basic database that will generate a report that will act as our daily production schedule. We make plastic bottles and have about 250 SKU's or so in the system. I have them all entered with all the details (resin, colorant, packaging, etc.).

Now I want to write a query that will ask the scheduler which items they want to run for a 24 hour period so they will print out on the report (all the details included). I need to be able to accept multiple items over multiple production lines. Can I do this with a single query? How many items can I return on a parameter query?



If not possible, is there another way to accomplish what I am trying to do?

Thanks.

[orange]

Do you really want an operator to type into a query where you may get spelling errors or other issues?
Suggest you consider a form on which the operator can make selections from prepopulated lists or comboboxes. This will prevent spelling, typos and illogical choices.

There are samples here
http://www.fontstuff.com/access/acctut17.htm

[Joe Heiser]

Thanks Orange! No, the operator will not be the one typing anything in. The scheduler will be doing that. The form will be able to collect multiple (up to about 20 or so) items to run that day?

[SteveF]

Thanks Orange! No, the operator will not be the one typing anything in. The scheduler will be doing that. The form will be able to collect multiple (up to about 20 or so) items to run that day?

If the form is built right, yes. I suggest a "continuous form" style, where you can have a table-like display with each row of the form corresponding to an item to be run. Put any titles, headers, command buttons, etc. in either the header or footer section of the form.

Drop a combo box into the detail section of the form for each attribute of the item that the scheduler needs to specify (e.g. SKU, production line, etc.). Once all the items to be run are entered, a button on the form can print out the daily schedule, individual work orders, etc.

Steve

[Joe Heiser]

SteveF: I have a table of items (SKUs)that we run in production, it includes all the bill of material item fields associated with that particular item (ie resin, colorant, corrugate, pallet, etc.). I want to be able to prompt the scheduler to pick a certain item, and then have all the bill of material items associated, print out on a report in a nice format.

I can do that with one item easily, however, we run several items the same day, and the scheduler needs to be able to pick them all and have them each print on the same report with all of their details (which are linked to each item). I can do that with a select query for one item, but that is all. I need to be able to do it for several SKUs.

How would I go about prompting the scheduler to enter say, the 4 SKUs he wants to run and the quantity for each item, and then have each SKU print up individually (with all associated details) on the report in an ordered fashion?

Thanks.