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

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

Guest

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
 
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]
 
Duane,
Thank you very much!
That works perfectly!
Tom

Duane Hookom said:
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]

--
Duane Hookom
MS Access MVP
--

Tom said:
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
Click to expand...
Click to expand...
 
Duane Hookom said:
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]

--
Duane Hookom
MS Access MVP
--

Tom said:
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
Click to expand...

this is what i need to do but I am new to access & not sure how to implement this string.
Click to expand...

could you please give a small example?
 
Back
Top