varying quantity of address labels

Hi all

I have been supplied with a database that has 200 records:

Name, Number of copies (magazines).



Mr Smith, 80

Mrs Jones, 120

Miss Brown, 55 etc



I need to print address labels to attach to each magazine



Therefore Mr Smith = 80 labels, Mrs Jones = 120 labels



How is this best achieved



All the best Garry

Garry wrote:
I have been supplied with a database that has 200 records:

Name, Number of copies (magazines).

Mr Smith, 80
Mrs Jones, 120
Miss Brown, 55 etc

I need to print address labels to attach to each magazine

Therefore Mr Smith = 80 labels, Mrs Jones = 120 labels


Create a table (named Numbers) with one field (named Num)
and populated with record values 1,2,3,... up to more labels
that you will ever need.

Then create a query like:

SELECT name, Num
FROM yourtable, Numbers
WHERE Num = [Number of copies]

and base your label report on the query.

--
Marsh
MVP [MS Access]

How could it be so simple !

You have saved me hours of work

Many thanks, Garry


"Marshall Barton" wrote in message
...
Garry wrote:
I have been supplied with a database that has 200 records:

Name, Number of copies (magazines).

Mr Smith, 80
Mrs Jones, 120
Miss Brown, 55 etc

I need to print address labels to attach to each magazine

Therefore Mr Smith = 80 labels, Mrs Jones = 120 labels


Create a table (named Numbers) with one field (named Num)
and populated with record values 1,2,3,... up to more labels
that you will ever need.

Then create a query like:

SELECT name, Num
FROM yourtable, Numbers
WHERE Num = [Number of copies]

and base your label report on the query.

--
Marsh
MVP [MS Access]