CREATING duplicates

laxster

Registered User.
Local time
Today, 17:42
Joined
Aug 25, 2009
Messages
145
So I actually have this odd need to CREATE duplicates in a table. Accidental duplicates were always a problem, but intentionally creating them is quite another thing.

I have a table, and the first record of the table needs to be duplicated 30 times.

How would I go about writing a query to do this?
 
Sorry to ask, but someone would if it wasn't me - Why do you need to do this? What is in the record that you need it repeated 30 times? If you give us the WHOLE story, it sometimes helps.
 
Unless there's a better way of doing this... I have one table that uses a query to match up to another table to generate labels in a report. I used the Microsoft report label generator function in Access to come up with the formatting of the label sheets I need. The thing is, I can't find a way to show the same label 30 times down the report unless there are 30 records. Unless I can somehow duplicate the same label 30 times down (one would imagine this is possible) the only work-around I can think of is to generate 30 duplicates to fill the sheet.

Is there a better way of doing this? If not, how can I simply duplicate the record 30 times?
 
create a table which has a single column (integer) and create your records 1 to 30.

Then create a query from your other table and this table but do not link anything. That will create a cartesian product which will give you the number of records - Table 1 Times Table 2. So if Table1 is your numbers and Table2 only has 1 record, then the query will repeat record 1 from Table 2 - 30 times.
 

Users who are viewing this thread

Back
Top Bottom