Criteria for a query

Take this:

1. Create a Helper Table

• Name it tblNumbers
• Add a single field Num (Integer Type)
• Populate it with sequential numbers (1, 2, 3, … up to a reasonable maximum)

2. Create a Query to Dynamically Duplicate Rows

SELECT YourTable.Date, YourTable.Code, YourTable.Description
FROM YourTable, tblNumbers
WHERE tblNumbers.Num <= [Enter Number of Duplicates];

• The [Enter Number of Duplicates] prompt will ask the user for the number of times they want each record to appear.
• The tblNumbers.Num <= ensures that only the specified number of duplicates is included.