Bernie said:
I would like to have the append query create a fixed number of rows based on
the value from a field value.
For example, field value = 10. I would like my append query to create 10
records.
You could do that using a VBA procedure and add the rows
through a record set opened on the destination table.
If you want to do it using a query, then create a little
utility table called Numbers with one field named Num.
Populate the table with records containing 1, 2, 3, ... up
to a 100 or whatever.
Then the query could look like:
INSERT INTO destinationtable (f1, f2, ...)
SELECT f1, f2, ...
FROM sourcetable, Numbers
WHERE fx = keyfieldofrecordtoappend
AND Num <= fieldvalue