Finding the values

C

confusedinc

Hi,
I am new to Access programming and I am needing to find out how create a
query to get information on patient accounts that are in arrears : 30 days,
60 days and 90 days past due.
Hope it makes sense.
 
R

Rick B

We'd need to know more about your data structure before we could answer
that. This would be done by one or more queries that would locate all
unpaid invoices and compare the invoice due date to the current date. One
query would pull all those records where the difference was between 30 and
59 days, the next would find all the records between 60 and 89 days, etc.
 
C

confusedinc

Thanks Rick,
What I have is this,
I will be billing the last day of each month, and will need to have a way to
track payments that are late by 30, 60, or 90 days. Hope this helps
I am just starting on this project, so I don't have a lot to go by yet.
 
Top