as I loop through the file I copy the current YTD and total Archive data into the appropriate fields,
I don't see any need to copy any data via a looping script. That both creates redundant copies of your data and is slow.
You can match to record via a date range without any need to copy data and you can use that relationship to pull up aggregate values such as counts and totals.
To match by a date range you use one of two relationship methods:
Table1::DateStart > Table2::Date AND
Table1::DateEnd < Table2::date
or you can use:
Table1::DateList = Table2::Date
where DateList is a return separated list of Dates from DateStart toe DateEnd. Both DateStart and DateEnd can be global fields and you can use a custom dialog to ask the user for these two dates.
Thank you, that solved my problem and I'm percolating along again.