Sequence numbering labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Used Label Wizard to design report/label

All the data on the label (destinee address) is the same except for: Box
1 of 20

Easy enough to insert the 20 since that is a known single value....

But to have labels sequence thru 1 of - 2 of - 3 of etc.. isn't jumping
out to me as obvious when working with a single label report template in
design view....

would welcome advice from those out there that have set this up before
--thanks
NTC
 
much thanks - working fine. I can definitely see why this must be an oft
repeated question ....MS probably should consider making it a clickable
embedded feature....

you know though there was the first sentance of your #4 about 'dragging the
table field to the query output grid' ...that I did not understand, didn't
do, and didn't need...so it has me a little baffled..just thought I would
mention it to you....

Following your prior instructions I already have that one column count field
showing in the query output grid already as a natural result of query - -
and put that count field into the label via label wizard.

honestly I didn't know that one could mechanically drag a table column (or
anything) to a query's resulting output grid - - maybe I misunderstand your
meaning - will play around with it some this weekend.....

on another related topic involving labeling....the question is a different
kind of series sequencing : when the contents of a box are sequential people
want the series also on the outside label. So besides box 1 of 10 there is
also Series 1 to 500 , Series 501 to 1000, etc.

now I'm wondering on approach. Does one generate these series values via VB
module and then attempt to plug them into a table - and then generate the
label from that table. Or create calculated fields as part of a query. Or is
there also a method that these values would be generated on the fly as part
of label creation.
 
Regarding dragging a field into the grid in query design view, give it a
shot. The upper pane of the query design window contains the tables. The
lower pane is the output grid. You can drag a field from the table in the
upper pane, and drag it onto the Field row where you want the field to be.
Any other fields to the right of when you dropped the field will scoot
right, so the field stays where you placed it. (Double-clicking the field in
the table also adds it to the output grid--to the right of all other fields
in the grid.)

Your further question will require you to define how the boxes are packaged.
If there are always a fixed number of items in a box for a given product,
you could use integer division to get the box number, e.g.:
="Box " & (([CountID] \ [HowManyInBox]) + 1)
 
Ok - clarity on the first part regarding dragging - definitely I understand
this in 'design mode'....I interpreted your language of your web page to say
'Output Grid'...and this was, in my mind, the query result.....so that's
cleared up...

As for variable series sequence numbering on labels:
So if I use a formula - such as ="Box " & (([CountID] \ [HowManyInBox]) + 1)
I could put this in the label/report design and it would calculate this on
the fly when the labels create giving me different numbers - that would work.

I hadn't realized one could have a calculation in the report/label design
like this - very very helpful....thanks again....
--
NTC


Allen Browne said:
Regarding dragging a field into the grid in query design view, give it a
shot. The upper pane of the query design window contains the tables. The
lower pane is the output grid. You can drag a field from the table in the
upper pane, and drag it onto the Field row where you want the field to be.
Any other fields to the right of when you dropped the field will scoot
right, so the field stays where you placed it. (Double-clicking the field in
the table also adds it to the output grid--to the right of all other fields
in the grid.)

Your further question will require you to define how the boxes are packaged.
If there are always a fixed number of items in a box for a given product,
you could use integer division to get the box number, e.g.:
="Box " & (([CountID] \ [HowManyInBox]) + 1)
Click to expand...
 
Back
Top