Duplicate a row

[thestappa]

Hello all,



I'm looking for the easiest way to duplicate a row in a table. I have some tables for a budgeting program that have rows separated by HOURS and DOLLARS (TYPE). Pretty basic. However, some of the rows (by design) don't have data in the TYPE field.

What am need to do with those rows is duplicate the row in the table, then give one of the rows TYPE HOURS and the other TYPE DOLLARS.

I'm not sure how to accomplish this in Access. In my mind I would do something like below.

1) Loop through records with TYPE null
2) For each record copy entire recordset into table with DOLLARS in the type field
3) Update the remaining records with TYPE null to have TYPE HOURS.

I'm not sure how to pull off step 2 easily.

[TheShabz]

I dont understand why you need to duplicate. why not have HOURS and DOLLARS as fields and just indicate via yes/no or however you want. One record is all that is needed. Am I misunderstanding?

[thestappa]

I dont understand why you need to duplicate. why not have HOURS and DOLLARS as fields and just indicate via yes/no or however you want. One record is all that is needed. Am I misunderstanding?

I don't have it that way because I need one row for HOURS and one row for DOLLARS. There will also be UNITS but that isn't an issue, yet...

It's a good question, but in this application I have legitimate reasons why I need to have what are basically duplicate rows.

[TheShabz]

Well, if your table has only 1 instance per record, you can create a second table that holds all the values you want for TYPE and then run a query with it without using a join. You'll create a Cartesian product and have 1 instance of each record each with 1 of the TYPEs.

...finally a positive outcome of a Cartesian product.