aging accounts

[sherwin]

Good day!

I am monitoring the remittance of about 700 employers remitting health
insurance premiums. My task right now is to determine aging accounts. The
first thing I did was make a table of months. Second, I made a query showing
the months that each employer should have remittance. Then, I made a query
asking to show months without remittance. From there I calculated the aging.
But I have problems, one, not all of these employers started operating at the
same period. For example, Employer A started operating March 2010 so premium
contribution will also start on this month. However, the query asking to show
months without remittance will show both January and February 2010 for this
employer. Therefore, the query on aging will also count for these months. How
will I solved this?

Thank you, i really need the answer so badly.

 

[Tom van Stiphout]

On Thu, 22 Apr 2010 19:53:01 -0700, sherwin

I don't know your table design, but generally speaking you would add
to the WHERE clause a condition that says:
myPremiumContributionMonth >= myEmployerStartMonth

-Tom.
Microsoft Access MVP

 

[sherwin]

Sir,

My table of months looks like this:

MonthFrom MonthTo Deadline
January 2010 January 2010 February 10, 2010

 

[John W. Vinson]

Sir,

My table of months looks like this:

MonthFrom MonthTo Deadline
January 2010 January 2010 February 10, 2010

Are these Date/Time fields (which would be good) or Text fields (which will
require some extra code)?