Need Suggestions on How to create a PACKING SLIP REPORT based on Sales Table

[rajgoyal00]

hi,
I was wondering if I can get some help. I am a newbie and I have gotten better on SQl and VBA, but have very little to practically no experience with REPORTS. I am using 2010 access.
I am at the end of the DB and I need to create a couple of reports and finalize the DB.
The report I am working on now is a Packing Slip Report.

I have an unboud form with all unbound fields to enter a SALE.
It INSERTS into my SALES table in these fields " Product_Code (TEXT), Price (Currency), Date_of_Sale ( date() ), PROCESSED (yes/No Field)
And it UPDATES Qty in the PRODUCT table which contains "Product_Code (Text) same as above, Product Description (Text), Qty_on_Hand (Number)
That Same form has a Sales SUBForm in Datasheet view shows the sales I make from the sales table and the PROCESSED field is always NO

I want to have a button that says PROCESS. After I am done entering the sales information, I click PROCESS that creates and prints one Packing slip (Report) and for each item sold Based on Sales Table and Products Table. And after its done creating reports, it will check PROCESSED field YES. so the next sales for the same day won't print again.

I can manage everything else but the REPORT itself.

I have created a query joining Sales Table and Products Table on PRODUCT CODE.

Shows- Product Code (sales table), Product Description (Products Table),Qty (Sales Table), Price (Sales Table), Date_of_Sale (Sales Table), Processed (Sales Table)

I used report, it puts all the producr code on the same page, I am very confused on how make it happen, since I have no experience with reports at all



Please help!!!!!!!!!!!!

[Dal Jeanis]

First, make sure that your query limits the records it is pulling to only those records that are on a particular sale. You should be creating a sale record that has a unique ID, and putting that unique ID on all the individual item sale so you can tell all the records associated with that one sale.

Second, change the report to create one page per record. If nothing else, you can sort by Item ID and put a page break before each new item ID.

[rajgoyal00]

I am using the date, Product code, and processed for the criteria to pull only that day's sale which are not processed. I will try ther other suggestions and see what happens.. thanks