need a real report wizard!! (1 Viewer)

Trying to Print a work order with data from 2 Queries
each productid would have its own page with the quantity need to manufacture and the formula for that product from query 2

Query 1 contains the following

Productid ......... Productname .......... Quantity to Manufacture
1....................... blue....................... 100
2.............. .......... Green .................. 50


Query 2 contains the following

Productid.......Productname.......Manufactprt#........ Description........quantity
1 ..................Blue ................ zyz123 .............. blue part .............. 7.8
1 ............... . Blue ............ ..... abc ............ ..... jar ..................... 1
1................ Blue ................... lmm ................. label .................... 1
2............... green....................agd..................green part..................8.9
2................ green.................. 123..................... jar........................1
2 ..................green..................def ......................label..................... 1

have Access make an instant report.
Then edit it, and put in PRODID group. At the PRODID footer, insert a page break,
so each product is on its own page.