Is there a way to duplicate records in an Access table?

  • Thread starter Thread starter JSL
  • Start date Start date
J

JSL

The data I imported has a "quantity" field that may be >100 but I need
individual records for each of the 100. Currently the item listed is 1
record. I know how to duplicate the field above using CTRL+", but am looking
for an easier way to duplicate the entire record (about 100 times).
 
Create a table named CountNumber with field named CountNUM containing 1 to 100.
Put both tables in your append query. Add CountNUM to the field row of the
grid and criteria of <=[quantity]
 
Back
Top