Looking for a report or query...

[jourdo]

Is there something out there that will allow me just to print off patient payments for a given time period? It is that time of year where patients are asking for statements for income tax purposes. If I could give them something with just their payments, and none of the other stuff, I think that would make things easier for them.

Any ideas?

[Tom Zaccaria]

Patient payments for a date range.

Try this but change the dates if necessary.

/*75*/ SET @StartDate='2012-01-01';
SET @EndDate='2012-12-31';
SET @PatientNumber=6179;
SELECT * FROM paysplit WHERE
DatePay>=@StartDate AND
DatePay<=@EndDate AND
PatNum=@PatientNumber;

drtmz

[Tom Zaccaria]

Modified it slightly to this:

Change dates and patient number as needed

/*75*/
SET @StartDate='2012-01-01';
SET @EndDate='2012-12-31';
SET @PatientNumber=424;
SELECT Patnum, ProcDate, SplitAmt, ProvNum, DatePay
FROM paysplit WHERE
DatePay>=@StartDate AND
DatePay<=@EndDate AND
PatNum=@PatientNumber;