Report to query multiple entries

[bigern87]

I want to create a report that will take two tables that I have and link them and give me the output. Basically this is what I have: 3 fields primarily. 1. MRP Code which links the 2 tables together, 2. Part number, and 3. Planner name. I want to be able to link the part number to the planner name.



Generally I want the report to be setup so that a user can paste a large list of part numbers and the output would be the planner names associated with the part. Let me know if you can help with this.

[ranman256]

It sounds like you have it mostly done.
If you want a report on a single item, then you will need a 'report form'
with a combo box for either planner or part. (i use mostly date ranges)

the query would look at the combo to pull the records with the filter where [part] = '" & forms!frmRpts!cboParts & "'"
the report would connect to this query.

What do you need exactly?

[bigern87]

I want to report on multiple items. I want to be able to input a list of parts possibly separated by ";" or something like that and then get an output.

[NTC]

so you probably know that in the end it has to be correct SQL syntax and in your case I think primarily an OR statement....and so when you say " paste a large list of part numbers " - somewhere behind the scenes you need to transform that to the correct SQL....

one can manipulate strings and replace the ":" symbol with OR and dynamically make up an SQL statement on the fly ....one could set up a multi value list box..... part of the answer is going to depend on how you want the user experience to go.....

[June7]

Review
http://allenbrowne.com/ser-50.html
http://www.allenbrowne.com/ser-62.html