You are looking for commercial software likely costing many thousands of dollars. I strongly suspect that you will not find a freebie here or anywhere. That type of system is usually highly specialized and (usually) customized to some degree per site.
ashuag i think this is almost not possible to get exact solution which you want ,there so many opensource application dealing with doctors , chemists , labs etc , in order to get better solution according to your prob you have to hire a professional programmer or develop it by your slef , we here to help you at any step . but you have to take your first step . :)
Dim Adapter As New OleDbDataAdapter
Dim Command As New OleDbCommand
Dim xFrom As String = dtpFrom.Value.ToString.Substring(0, dtpFrom.Value.ToString.IndexOf(" "))
Dim xTo As String = dtpTo.Value.ToString.Substring(0, dtpTo.Value.ToString.IndexOf(" "))
sqlQuery = MainQuery ...