First, I want to say that what I did was probably really, really dumb. When you think about it, the middle of a tax year doesn't seem like a good time to purge and archive records.

But I did.

Now as I begin to work on my Sales Tax Return, I wish I hadn't.

Can I somehow merge archived records into my current DB? Otherwise, it looks to me as if I should do the reports from my current DB, back it up, and restore the archived stuff (thus wiping out the current data), run the reports on the archived stuff, and then restore to the current data.

This sounds loony enough that I thought I'd ask first.

Ned