displaying data from 3 queries

  • Thread starter Thread starter ecwhite
  • Start date Start date
E

ecwhite

Hello,

I have three queries for each role of physcian e.g attending, admitting and
as surgeon. one physician can have all three roles. I am displaying their
patient count for each patient type in a report and i am looking for the
best way to do this using access. IP stand for Inpatient Patient Count, OP
stands for OutPatient Count
example

Doc Id as admitting Doc as ttending Doc as Surgeon

IP OP IP OP
IP OP

000000 20 10 0 90 20
30

000001 1 30 90 10 5
80

000003 0 9 4 5 5
6

Please help. I have thought of using cross tab query and then building a
report out of it but I have not got it to worl perfectly.

Thanks,
white.
 
If you told us what data you are keeping, and the structure in which you are
keeping it, someone might be able to offer suggestions. Without some
understanding of the underlying data, it is difficult at best; imposible at
worst, to design a report. And, with the line wrap and differing display of
news readers, trying to type in a "formatted" example is problematical.

Larry Linson
Microsoft Office Access MVP


ecwhite said:
Hello,

I have three queries for each role of physcian e.g attending, admitting
and
as surgeon. one physician can have all three roles. I am displaying their
patient count for each patient type in a report and i am looking for the
best way to do this using access. IP stand for Inpatient Patient Count, OP
stands for OutPatient Count
example

Doc Id as admitting Doc as ttending Doc as Surgeon

IP OP IP OP
IP OP

000000 20 10 0 90 20
30

000001 1 30 90 10 5
80

000003 0 9 4 5
5
6

Please help. I have thought of using cross tab query and then building a
report out of it but I have not got it to worl perfectly.

Thanks,
white.

__________ Information from ESET Smart Security, version of virus
signature database 4038 (20090427) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...



__________ Information from ESET Smart Security, version of virus signature database 4038 (20090427) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Hello,

The data is exactly like i showed in my example below. I have the docid, his
Inpatient and outpatient patient count for the date range put in the query
which is suppose to be monthly patient count displayed under the doc's role.
it will be arranged in the format i showed below. I am looking for suggestion
on how to arrange the fields that i just talked about to look like the sample
i showed below.

Thanks.
 
If the "data is exactly like i showed in my example below" then simply report
it. I expect/hope however your actual data is stored in more normalized
tables with some date fields etc. If you don't provide the actual structure
and relationships, we can't be of much assistance.
 
Back
Top