Creating multiple/duplicate records for output

[battenberg]

Hi

I am writing mini database which will produce labels for boxes. I want to be able to produce a sheet of labels based on the 'number of labels' to print field. I can output one label or many on the page/s depending on how I structure the query and how many records are in the query.

My Question:
I need is a query which takes an individual record and duplicates it by the integer in the 'Number of Labels' field

any ideas?

thanks

 

[MicroE]

Check out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;231801&Product=acc

 

[battenberg]

MicroE,

just wanted to say a great big thanks for pointing me in the right direction... It's taken 'till now to get it to work, but that link was exactly what I needed!!!

thanks again

Batt.

 

[MicroE]

You are welcome – glad you were able to get it working. It is a very useful function. Make sure to save it for future projects,