I need to generate a table for building a chart, using data from an existing
query.

Here's the scenario:
Each existing record contains a starting date, current value and rate of
return. From each record, I need a value (record) generated for each
successive year (up to a cutoff date), which I can then chart from the
table.

I suspect I'll have to build some looping code and append each iteration of
the loop to the new table.

Any suggestions?

Thanks
REB