>If I have a table with two records and I want to creat a query with 6 duplicates of each record, how would one go about doing this?
You can SELECT INTO TABLE 3 times. Then, you select your main alias and APPEND FROM yourtable.DBF. You may want to readjust the primary keys after, if you have some.