Label Count

[klp via AccessMonster.com]

I have a report, based on the label wizard, that needs to be 4" X 3". However
it will not take it when it's sent to the printer. Therefore we are trying to
work our way around it by making it 4" X 6". It will then print 2 labels to a
page per say. What I need is a counter. If I put in that I need 10 labels it
will say "1 of 1, 1 of 2, 1 of 3" etc. I can't use the page function since
it thinks that it's 1 page. I would like to create some sort of counter. Not
sure if I need to use a query(SQL) or if I need to do something else. Any
suggestions please.

Thanks in advanced.

 

[John Spencer]

Assuming that each label is a detail row,
-- Add a control to your layout
-- Set its control source to =1
-- Set Running Sum to Over all or Over group (depending on your need)

That should give you a one-up number for each label.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[klp via AccessMonster.com]

Great, thank you!

Assuming that each label is a detail row,
-- Add a control to your layout
-- Set its control source to =1
-- Set Running Sum to Over all or Over group (depending on your need)

That should give you a one-up number for each label.

I have a report, based on the label wizard, that needs to be 4" X 3".
However

[quoted text clipped - 12 lines]

Thanks in advanced.