How to sequence a label "1 of 2", "2 of 2" in Access?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 09 Dec 2005 18:41 GMT

I actually have two questions:
I'm trying to print a label(s) in Access and would like to be able to print
"1 of 2", "2 of 2" etc on the bottom of each label. The user would need to
input the number of label they require, and then that would determine the "
__ of__" sequence.
How can:
1. The operator input their requirement for labels
2. The "__of __" be added to the label.
Thanks,
Tom

Reply to this Message

Duane Hookom - 09 Dec 2005 20:50 GMT

Create a table of numbers (tblNums) with a single numeric field (Num) and
add records 1 - [max required number].
Add this table to your report's record source and set the criteria under Num
column to
<=[Enter Number to Print]

Add a text box to your label with a control source of:
=[Num] & " of " & [Enter Number to Print]

Signature

Duane Hookom
MS Access MVP
--

>I actually have two questions:
> I'm trying to print a label(s) in Access and would like to be able to
[quoted text clipped - 8 lines]
> Thanks,
> Tom

Reply to this Message

Tom - 12 Dec 2005 12:50 GMT

Duane,
Thank you very much!
That works perfectly!
Tom

> Create a table of numbers (tblNums) with a single numeric field (Num) and
> add records 1 - [max required number].
[quoted text clipped - 17 lines]
> > Thanks,
> > Tom

Reply to this Message