Itemize Report with PRINT

[TWINKLEMARVEL]

Can somebody help in getting a code for the below:

Workbook "Inventory.xls"

sheet "Lookuplists " :

Range A - Employee
Range B - Client
Range C - Job
Range D - Rate

Sheet "Data" :

Range A - Employee
Range B - Client
Range C - Job
Range D - Date
Range E - Qty

cmdprint ------ Print

There are two user forms.
1st user form contains the following :

Userform .... frmremunerationreport

cboemployee

txtdate1
txtdate2

cmdgenerate


Based on the data form sheet "Data", and Sheet "LookupLists" I would like to get the total quantity of job done and Amount for each Job by selecting each employee, by providing FROM and TO date in " frmremunerationreport".

Upon clicking "cmdgenerate" , User form 2 which is "frmremunerationslip", should pop up, should have itemize report. i.e, for a specific employee the job done for CLIENT with QTY and AMOUNT should appear in the concern text box which should be printable.

USer Form 2 "frmremunerationslip" has got the following details


txtemployee

txtdate1 FROM date
txtdate2 TO date

txtclient1
txtclient2
txtclient3

txtjob1
txtjob2
txtjob3

txtqty1
txtqty2
txtqty3
txtqty4 ---- Total Qty ( Convert Quantity into Dozen and Display)

txtamount1
txtamount2
txtamount3
txtamount4 ---- Total Amount


Thanks