What is a good sql method of getting member months at a hmo.?
I use vfp5.0 ;have member tables with effective and expiration dates.
Is medicaid so there are some members who go in and out maybe as much
as 3 times a year.

Calculating the RPM's of a revolving door in St. Louis........