Requires Expert or Someone better then me.

  • Thread starter Thread starter Steven M. Britton
  • Start date Start date
S

Steven M. Britton

And that isn't that difficult.

I have my table that has Name, Address (typical) then it
has Item101Qty, Item201Qty. In item 101 and 201 a
customer my order the products. 101 are 6 plates for 19.95
+ S&H and 201 are 6 plates for Free + S&H. Now you may
order an unlimited amount of 101 and 201, my question now
begins with the report.

I need to create a packing slip that when customers order
2 or more of 101 & 201 it breaks out those quantities into
lines each time there is an order on the report.
(I.E. 6 plates 19.95 + 6.95 = 26.90; then on line two show
6 plates Free + 6.95 = 6.95; then on line three show 6
plates 19.95 + 6.95 = 26.90; and on line four show then on
line two show 6 plates Free + 6.95 = 6.95) I don't know
where to begin or if there is some sample code out there
that can just be added.

Thanks to anyone that can help.

Steven M. Britton
Contracts Administrator

Arc Enterprises
9575 Aero Drive
San Diego, CA 92123
Voice - (858) 571-4369 X-139
Fax - (858) 571-4370
 
First of all the way your tables are developed you are breaking
normalization rules as well as entity and referential integrity. Access has
an excellent pre-built database that you can use as a template;
Northwind.mdb. Study it thoroughly or make a copy and remove the existing
data and use it for your purposes. It will make your life allot simpler.
 
Back
Top