M
Mark
General Problem:
I have a table with dollar fields. I want to take each
record in the table and create several new records: each
new record would essentially be a copy of the original
but add a new field to identify the subtotal I want the
original record to show-up (e.g., month, quarter, year).
Likely Solution:
Using VBA, read the first record from original table and
output the new records to a second table.
Can anybody provide some code to get me started?
I have a table with dollar fields. I want to take each
record in the table and create several new records: each
new record would essentially be a copy of the original
but add a new field to identify the subtotal I want the
original record to show-up (e.g., month, quarter, year).
Likely Solution:
Using VBA, read the first record from original table and
output the new records to a second table.
Can anybody provide some code to get me started?