J
Jack W.
Recently, state agencies informed us that the regulation is changing and it
will require us to keep an even more detail report of the treatments we
provide to our patients. So, I thought that it would be easier to create an
access database to keep track of records and can also be used for billing.
I’ve never used access till now. I’ve done some of the simple tutorials
online and learned how to create table, query, form, and report.
This is how each therapists will keep track of their treatments. Each
patient has a medical record number(MRN), and each patient may receive more
than 1 treatment from the same therapist, but each treatment has to be
documented separately.
Here is an example of the tables I have created, since each patient may
receive more than 1 treatment(not unique), so I have access auto create
primary keys:
OT Table
MRN DATE Treatment Time Treatment Unit
1029 11/1/2008 20 2
1030 11/1/2008 20 2
1029 11/1/2008 10 1
PT Table
MRN DATE Treatment Time Treatment Unit
1029 11/1/2008 20 2
1030 11/1/2008 20 2
1029 11/1/2008 10 1
1031 11/1/2008 20 2
I have created a table, a query, a form for input, and a report for each
therapist. My problem is that when I try to create a report that combines
data from all of the therapist, I get duplicate data and missing patients.
For example, I would get 4 records of 1029 with data from both OT/PT
repeating itself 4 times, and 1032 will be missing from the list.
I assume it has something to do with the relationships between tables, but I
just can’t get it right. Maybe I need to set up tables in a different way,
but I have no idea how to do it differently.
What I want is to create a report for a whole month that’s sorted by MRN,
then categorized by each therapists, then sort by date for each therapist.
Of course, total treatment time and units for each therapist for each day.
So, it'll look something like
Report from 11/1/2009 to 11/30/2009
MRN 1029
OT
11/1/2009 20 2
11/1/2009 20 2
Total 40 4
PT
11/1/2009 20 2
11/1/2009 10 1
Total 30 4
Next MRN etc.
will require us to keep an even more detail report of the treatments we
provide to our patients. So, I thought that it would be easier to create an
access database to keep track of records and can also be used for billing.
I’ve never used access till now. I’ve done some of the simple tutorials
online and learned how to create table, query, form, and report.
This is how each therapists will keep track of their treatments. Each
patient has a medical record number(MRN), and each patient may receive more
than 1 treatment from the same therapist, but each treatment has to be
documented separately.
Here is an example of the tables I have created, since each patient may
receive more than 1 treatment(not unique), so I have access auto create
primary keys:
OT Table
MRN DATE Treatment Time Treatment Unit
1029 11/1/2008 20 2
1030 11/1/2008 20 2
1029 11/1/2008 10 1
PT Table
MRN DATE Treatment Time Treatment Unit
1029 11/1/2008 20 2
1030 11/1/2008 20 2
1029 11/1/2008 10 1
1031 11/1/2008 20 2
I have created a table, a query, a form for input, and a report for each
therapist. My problem is that when I try to create a report that combines
data from all of the therapist, I get duplicate data and missing patients.
For example, I would get 4 records of 1029 with data from both OT/PT
repeating itself 4 times, and 1032 will be missing from the list.
I assume it has something to do with the relationships between tables, but I
just can’t get it right. Maybe I need to set up tables in a different way,
but I have no idea how to do it differently.
What I want is to create a report for a whole month that’s sorted by MRN,
then categorized by each therapists, then sort by date for each therapist.
Of course, total treatment time and units for each therapist for each day.
So, it'll look something like
Report from 11/1/2009 to 11/30/2009
MRN 1029
OT
11/1/2009 20 2
11/1/2009 20 2
Total 40 4
PT
11/1/2009 20 2
11/1/2009 10 1
Total 30 4
Next MRN etc.