aging accounts

  • Thread starter Thread starter sherwin
  • Start date Start date
S

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.
 
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
 
Sir,

My table of months looks like this:

MonthFrom MonthTo Deadline
January 2010 January 2010 February 10, 2010
 
Sir,

My table of months looks like this:

MonthFrom MonthTo Deadline
January 2010 January 2010 February 10, 2010
Click to expand...

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