If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Finding the values
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. |
#2
|
|||
|
|||
Finding the values
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. -- Rick B "confusedinc" wrote in message ... 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. |
#3
|
|||
|
|||
Finding the values
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. "Rick B" wrote: 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. -- Rick B "confusedinc" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Finding number of values in a range on a per year basis | LyleB_Austin | Worksheet Functions | 2 | September 20th, 2005 09:49 PM |
Using Match function with duplicate values in an array | Richard | Worksheet Functions | 2 | June 30th, 2005 10:20 PM |
How to calculate values from 2 tables | Luke | Running & Setting Up Queries | 2 | December 9th, 2004 03:55 PM |
Combo box returns numeric values | Joe | Running & Setting Up Queries | 5 | December 1st, 2004 03:03 PM |
Finding Duplicate Values on the Same Record | Ting | Running & Setting Up Queries | 4 | September 17th, 2004 01:24 PM |