Newbie Duplicates question

[jaconat]

Hi

I have a Customer table with a number of fields including ID (unique primary key), Name, Address and LabelCount (integer).

What I want to do is produce a mailing list report/query which will print out the number of address labels (taken from the field LabelCount) for each record in Customer.

So, for example

1, John Smith, 2 Long Drive, 5
2, James Jones, 4 Some St, 2
3, Billy Bob, 8 High St, 0

The report will print out 5 address labels for John Smith, 2 for James Jones and none for Billy Bob.

Thank you all for any help you can give.

Jaconat

 

[oldaf294]

jaconat,
This solution, thanks to CosmoKramer several years ago, works very well.

Add a table to your database that only has one number field. Populate this table "Number" to contain sequential numbers 1 to whatever the maximum number of labels you would ever print.
Add this table to the query that is the record source for your report. Don't join it.
Add the field that contains the "Numbers" to the query grid and set the criteria for this field to:
Between 1 And [labelcount]
In the [labelcount] "Criteria" type: >0

jim

 

[jaconat]

Jim

Many thanks for the solution. Works beautifully. As always it's easy when you know how!

Jaconat