Comment by arethuza

I'd go for two views - one, as you describe, that gives you the "active" records and another that gives you the "inactive" records.