Putting together a summary report that consist of mostly counting.

[hallm]

I have a table that stores individual patient records for a small medical database. Some of the fields are Patient Name, Doctor, Admitted, Physician Consulted, etc.

I'm trying to make a summary report that by doctor will show the total visits, total admits, total physician's consulted. Get averages per doctor, then averages for the clinic.

The problem I'm having is that in order to count the items, the only way I know how is to create a query for each thing. For instance, a query to count total visits by doctor, a query to count total visits all doctors, a query to count admits per doctor, a query to count admits for the entire hospital.

I'm just not sure of how to incorporate all of the queries into one report.

I'm not looking for anyone to write code for me, just maybe a kick in the right direction, or to a similiar tutorial.

Thanks,

Marion

 

[Trendsetter]

You can make a report header/footer based on Doctor!
This will let you show the individual entries in the detail section but in the Header show 1 specific doctor with his own footer of the total for that doctor.. then at the end of the report of all doctors show a grand total for all the doctors.

Look under view in report design and tick Report Header/Footer

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[hallm]

Thanks,

I'll try that.

 

[Trendsetter]

I thought through what I posted and have sent you in the wrong direction....
In design view of the report you need to go to Grouping etc.. the omega sign - the the first row - select Doctor and underneath select yes to header and footer - this will put 2 new bands on your report which can now be set to the doctors name and the totals as required

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk