varying quantity of address labels

[Garry]

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

 

[Marshall Barton]

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.

 

[Garry]

How could it be so simple !

You have saved me hours of work

Many thanks, Garry

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.