Produce Multiple Labels

  • Thread starter Thread starter Theresa
  • Start date Start date
T

Theresa

I have a table containing 2 fields: Customer Name, # of
Entries.

I want to create multiple labels for each customer based
on the number in the # of entries field.

Is there any way to do this? Any help would be
appreciated.
 
There are a couple methods for doing this. I suggest you create a table of
numbers tblNums with a single numeric field [Num]. Add records with values
of 1 through the maximum number of "enteries" values.
1
2
3
4
...
Add this table to your reports recordsource and don't create any join lines.
Add the Num field to the query grid and set its criteria to:
<=[# of Entries]

Duane Hookom
MS Access MVP
 
Thank you very much. It works like a dream!

-----Original Message-----
There are a couple methods for doing this. I suggest you create a table of
numbers tblNums with a single numeric field [Num]. Add records with values
of 1 through the maximum number of "enteries" values.
1
2
3
4
...
Add this table to your reports recordsource and don't create any join lines.
Add the Num field to the query grid and set its criteria to:
<=[# of Entries]

Duane Hookom
MS Access MVP

Theresa said:
I have a table containing 2 fields: Customer Name, # of
Entries.

I want to create multiple labels for each customer based
on the number in the # of entries field.

Is there any way to do this? Any help would be
appreciated.
Click to expand...


.
Click to expand...
 
Back
Top