Print multiple copies of report base on query criteria

[LD1010]

I have report [rptWORequests] used to process Work Orders for employees. The form I use to enter the information is set up to schedule multiple workers for a specific job on a specific date. Each record in the underlying table contains (among other data) a JobNumber, a WorkOrderDate and the EmployeeNumber/Name of anywhere from 1 to 6 employees, there are six employee fields, [Emp1], [Emp2] etc. Work Orders are printed based on the date the work is to be performed. This all works fine, but right now I can only figure out how to print one work order per job showing the names of each employee scheduled to work on that job on that date. What I really want (and can't figure out how to do) is to print out one work order for each employee scheduled. If three employees were scheduled for this job it would print three work orders, each with the JobNumber, WorkOrderDate and one of the three employee's Name/Number on it.

Is this possible? Any help would be much appreciated!

 

[Lilliabeth]

there are six employee fields, [Emp1], [Emp2] etc.

That's the problem - the table violates the first rule of database design (1st Normal Form).

http://en.wikipedia.org/wiki/Database_normalization#First_normal_form

You really should change your design as soon as you can. Aside from the obvious question (what if you hire a 7th person?), you will always have unnecessarily complex querying issues. The time to fix it will never be better than it is right now.





Lilliabeth
-Why use a big word when a diminutive one will do?-

 

[dhookom]

If you can't or won't normalize your table structure, you can use a union query to create a normalized view of your data. This is however a patch.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]