Well just a few ideas, but you may need to figure out what your are trying to do. To get all active patints, you:
Demographics | Inactive | False (this will give you all your active patients.
To give all active patients with Aetna, you set up that query, then do another query.
Demographics | Insurance | Type Aetna or Cigna (but this is where I am losing you.
That will only give you 150 or so patients.
For active patients for less than three years, you use the top query, then in the Category field choose
Schedule > Not seen in last X months as the second query. This should give you your active group and seen in the last many years.
This info can be exported, and exporting it to an Excel sheet would allow you to minipulate the date.
On the other hand, there is always my friend who could remote to your computer and do a query using SQL Server that would probably be much more useful.
