ThomasLafferty
Instructor
Hi there -
I need to be able to compare the percentage change for amounts over due (>60 Days, >90, >120).
The table in which the data resides is Current Month Aging History.
Here is the field list:
CUSTNO
NAME
DATE
OVER60
OVER90
OVER120
Here is the query I am currently using:
Here is what the output looks like:
In the report I would like to run from this, I need to show percentage change. Additionally, I would like a way of sorting it so that the worst offenders are first (i.e. last month, they had nothing over 60, now they have significant over 60).
Sorry for not being a bit clearer on this!
Born once die twice; born twice die once.
I need to be able to compare the percentage change for amounts over due (>60 Days, >90, >120).
The table in which the data resides is Current Month Aging History.
Here is the field list:
CUSTNO
NAME
DATE
OVER60
OVER90
OVER120
Here is the query I am currently using:
Code:
SELECT [Current Month Aging History].CUSTNO, [Current Month Aging History].NAME, [Current Month Aging History].DATE, [Current Month Aging History].OVER60, [Current Month Aging History].OVER90, [Current Month Aging History].OVER120, [Current Month Aging History].SALESREP
FROM [Current Month Aging History]
WHERE ((([Current Month Aging History].DATE)=DMax("[Date]","Current Month Aging History","Month([Date]) = Month(Date()) And Year([Date]) = Year(Date())") Or ([Current Month Aging History].DATE)=DMax("[Date]","Current Month Aging History","Month([Date]) = Month(Date())-1 And Year([Date]) = Year(Date())")))
ORDER BY [Current Month Aging History].NAME, [Current Month Aging History].DATE DESC;
Here is what the output looks like:
Code:
[b]CUSTNO NAME DATE OVER60 OVER90 OVER120[/b]
999999 FRED 09/30/07 0.00 35.75 0.00
999999 FRED 08/31/07 35.75 0.00 0.00
888888 WORM 09/30/07 0.00 0.00 0.00
888888 WORM 08/31/07 0.00 0.00 0.00
In the report I would like to run from this, I need to show percentage change. Additionally, I would like a way of sorting it so that the worst offenders are first (i.e. last month, they had nothing over 60, now they have significant over 60).
Sorry for not being a bit clearer on this!
Born once die twice; born twice die once.