G
Guest
I have a table with patient visits. Each visit may have multiple procedures.
ex j smith
1/1/07 procedure 97110
1/1/07 procedure 97140
I Want to count the total number of visits the patient has had.
I have a group by query which list the patient and groups the dates no
matter how many procedures are performed on a day which works fine
results of this query are
j smith 1/1/07
j smith 2/1/07
j smith 3/1/07
So the patient has had total of 3 visits.
I would like the query to return the total number of visits only
j smith 3
I know I can do this in a report but would like to get the values in the
query itself.
I need this number to use as a filter in other querys. Basically if a
patient has a certain insurance they may only be allowed 9 visits before they
need a new authorization. I would like to flag the outgoing claims before we
go past this number.
The office staff frequently misses these issues so this will reduce our
denials
ex j smith
1/1/07 procedure 97110
1/1/07 procedure 97140
I Want to count the total number of visits the patient has had.
I have a group by query which list the patient and groups the dates no
matter how many procedures are performed on a day which works fine
results of this query are
j smith 1/1/07
j smith 2/1/07
j smith 3/1/07
So the patient has had total of 3 visits.
I would like the query to return the total number of visits only
j smith 3
I know I can do this in a report but would like to get the values in the
query itself.
I need this number to use as a filter in other querys. Basically if a
patient has a certain insurance they may only be allowed 9 visits before they
need a new authorization. I would like to flag the outgoing claims before we
go past this number.
The office staff frequently misses these issues so this will reduce our
denials