Hello Mark,

>If it is just for backup, why not just create a single backup table and
>move all records into that table at year end. Then there is no need to
>create a table per year (and it is easier to provide a unified view on
>’archived' records).
>
>Mark

my apprehension is that the queries will slow if I take the many hundred-thousand records every year in a simple table.

Best regards.



Olaf



[Non-text portions of this message have been removed]