ReportDr00
IS-IT--Management
Hello
I would like to do the sum of units for each service based in which category they fall in
I have service table which stores all the services that client received.
I have billing table which stores all billing info
There are three categories:
first: 3rd Party
Is services billed to 3rd party then units of those service records are sumed
second: Medicaid
If services are billed to Medicaid then sum the units of those service records along with those service records that are not billed to anyone and excluding those one that are billed to 3rd party
third: client pay
If none of the services are billed to anyone on a day then sum the units of these services
For example if client has 5 services on a given day and two of which are billed to 3rd party then this should fall into 3rd party category and one service is billed to Medicaid and other two are not billed then all three fall into Medicaid category
If client has 3 services and none of them are billed then these fall into client pay category
If client has 4 services and 2 are billed to 3rd party and 2 are not billed, then 2 that are billed to 3rd party fall in 3rd party category and other 2 fall in client pay category
user will input service start date and service end date and report will return only those service records that fall with in the range.
sum of units for each service
service 3rd Party Medicaid ClientPay
date
01/01/05 2 3
05/03/05 2
07/01/05 2
09/10/05 2
Really appreciate your help
Armani