How to add a Serial no Field in Label Report?

[pmsuper]

Hi,

I have a label report in access xp, I want
to print the labels qty base on the record field "order Qty",
and also I want to have a serial no fields in the label,
but I don't know how to do, is it need to use a querry first
or add some code in the report,

Name OrderQty Serial No
-------------------------------------
A 5 5-1
A 5 5-2
A 5 5-3
A 5 5-4
A 5 5-5
B 2 2-1
B 2 2-2
C 1 1-1

Hope someone can help!!

Thank!!

pmsuperer

 

[Allen Browne]

See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

The article explains how to create a query that gives you a counter for each
record, and include the "serial no" on the label.

 

[pmsuper]

Thank!!

See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

The article explains how to create a query that gives you a counter for each
record, and include the "serial no" on the label.