I been trying to get a query written that will pull the previous months total for a facility so i can subtract it from the current month to get a change from the previous month to current month.
Here is my current query that I am stuck on
SELECT [CashFlow Link].LOCATION, [CashFlow Link].RCNAME, [CashFlow Link].Date1, [CashFlow Link].VISITS, [CashFlow Link].TOTCHG, [CashFlow Link].PAYMNT, [CashFlow Link].TOTCRD, [CashFlow Link].TOTAR, [CashFlow Link].PENCRD, [CashFlow Link].TOTDEB, (select PENCRD
from [CashFlow Link] as a
where a.RCNAME = [CashFlow Link].RCNAME
and [CashFlow Link].CLTFAC <> ''
and a.Date1 < [CashFlow Link].Date1) AS Previous
FROM [CashFlow Link]
WHERE ((([CashFlow Link].CLTFAC)<>''))
ORDER BY [CashFlow Link].Date1, [CashFlow Link].RCNAME;
Any help would be awesome
Here is my current query that I am stuck on
SELECT [CashFlow Link].LOCATION, [CashFlow Link].RCNAME, [CashFlow Link].Date1, [CashFlow Link].VISITS, [CashFlow Link].TOTCHG, [CashFlow Link].PAYMNT, [CashFlow Link].TOTCRD, [CashFlow Link].TOTAR, [CashFlow Link].PENCRD, [CashFlow Link].TOTDEB, (select PENCRD
from [CashFlow Link] as a
where a.RCNAME = [CashFlow Link].RCNAME
and [CashFlow Link].CLTFAC <> ''
and a.Date1 < [CashFlow Link].Date1) AS Previous
FROM [CashFlow Link]
WHERE ((([CashFlow Link].CLTFAC)<>''))
ORDER BY [CashFlow Link].Date1, [CashFlow Link].RCNAME;
Any help would be awesome