Can anyone direct me to a report or query that will total the payments received by payment type?
I would like to generate a total of all the payments by cash, credit card and personal check for the year 2008.
Thanks.
DRTMZ
Payment type totals
Re: Payment type totals
Try running this in the user query window:
set @startdate = '2008-01-01', @enddate = '2008-12-31';
select PayType, sum(payamt) $Total from payment where paydate between @startdate and @enddate group by paytype
Just edit dates at top for whatever range you want; format is YYYY-MM-DD.
set @startdate = '2008-01-01', @enddate = '2008-12-31';
select PayType, sum(payamt) $Total from payment where paydate between @startdate and @enddate group by paytype
Just edit dates at top for whatever range you want; format is YYYY-MM-DD.
DMA, Inc.
http://www.dmatechsolutions.com
http://www.dmatechsolutions.com
Re: Payment type totals
Perfect. Exactly what I was looking for.
DRTMZ
Tom Zaccaria
DRTMZ
Tom Zaccaria