How to handle “inactive” records?

[The_Doc_Man]

Give that queries can do filtration and sorting (and let you open them in datasheet view for verification purposes) and can easily be adjusted if needed to add more fields, more criteria, or more sorts, I see no fault whatsoever in that approach. Call that a "bit of positive feedback" if you like.