duplicate a record if the quantity is >1

[snipe]

Hey guys,

We have a program that gives a list of every item on our floors. We use this list to print labels and too inventory work. Here is a snip of what the query looks like:


This data is pretty much pulled directly from our ODBC.

If there is a an item with a quantity greater than 1, I need that record to be duplicated as many times as the quantity is over 1. I need an individual label for each peice. Make sense? The final table/query that gets exported needs to have all items have a quantity of one.

I guess what I need is to do an append query that duplicated each record by an amount of quantity minus one. How can I do that?

[June7]

I have a situation where I also have to print variable number of labels. I use VBA to write records to a 'temp' table. These records are purged from the table after each process.

It is also possible to trick Access into repeating a record when report is rendered. I do this to force report page to fill with blank rows. It's not easy to program and drove me nuts for a week before I got it to work. I tried to apply the technique to my label printing but my requirements are too complex.

Here is a link to thread asking your question back in 2005 and looks like Allen Browne came to the rescue http://bytes.com/topic/access/answer...-repeat-record

[snipe]

Interesting concept. I'll try it when I get back to the office on Monday. Thanks June7.

[snipe]

Wow that was incredible amounts of simple. Worked like a charm. I appreciate it as always!