Revision [167]
Last edited on 2008-11-10 17:01:57 by SethKriegerAdditions:
adjcode, fullnameid, trandate, payorname, amount
adjcode, fullnameid, payorname, SUM(amount)
adjcode, fullnameid, payorname
adjcode, fullnameid, payorname, SUM(amount)
adjcode, fullnameid, payorname
Deletions:
adjcode, fullnameid, SUM(amount), payorname
adjcode, fullnameid, payorname
Revision [166]
Edited on 2008-11-10 16:59:43 by SethKriegerAdditions:
and the summary query would be:
Deletions:
Revision [165]
Edited on 2008-11-10 16:59:21 by SethKriegerAdditions:
======Adjustments by Type and by Client for a Period======
Deletions:
Revision [164]
Edited on 2008-11-10 16:58:51 by SethKriegerAdditions:
======AdjustmentsByTypeByClientForPeriod Adjustments by Type and by Client for a Period======
I want a detailed or summary report of adjustments for a particular date range, grouped by type and then by client.
The detailed query would be:
SELECT
adjcode, fullnameid, trandate, amount, payorname
FROM
rv_credits
WHERE
credtype = 'Adjustment'
AND trandate BETWEEN '2000-01-01' AND '2008-07-31'
ORDER BY
adjcode, fullnameid, trandate
and the summary query woulbe be:
SELECT
adjcode, fullnameid, SUM(amount), payorname
FROM
rv_credits
WHERE
credtype = 'Adjustment'
AND trandate BETWEEN '2000-01-01' AND '2008-07-31'
GROUP BY
adjcode, fullnameid, payorname
ORDER BY
adjcode, fullnameid, payorname
I want a detailed or summary report of adjustments for a particular date range, grouped by type and then by client.
The detailed query would be:
SELECT
adjcode, fullnameid, trandate, amount, payorname
FROM
rv_credits
WHERE
credtype = 'Adjustment'
AND trandate BETWEEN '2000-01-01' AND '2008-07-31'
ORDER BY
adjcode, fullnameid, trandate
and the summary query woulbe be:
SELECT
adjcode, fullnameid, SUM(amount), payorname
FROM
rv_credits
WHERE
credtype = 'Adjustment'
AND trandate BETWEEN '2000-01-01' AND '2008-07-31'
GROUP BY
adjcode, fullnameid, payorname
ORDER BY
adjcode, fullnameid, payorname
Deletions:
comments here appear in italics
paste your tested query here
