Help Please

[Guest]

High
I have one report showing Patients data like "country"diagnosis,etc"
the report will order records by country and there is a header for the
country.

at the buttom of the report i want to put a summary like this
country No of Patients
country 1 10
country 2 2

etc

how can I do this , do I need to generate a subreport, and if so , where i
should place it , in the report footer or in the details section.

actully , I have tried putting a subreport in the rpt footer , but
unfortunately is shows only last country.althou when i open the subrpt
directly (alone) it gives correct results.

 

[Larry Linson]

Create another Report with its Record Source being a Totals Query, Grouped
by Country, with a Count of Number of Patients, then embed that in a
Subreport Control in the Report Footer.

Larry Linson
Microsoft Access MVP

 

[Guest]

thanks for reply
I have tried that for diagnosis and it workd ok. but when i tried it for
country is only gives the last country . although if you open the subreport
alone , it gives full . what could be the problem.

 

[Larry Linson]

I have tried that for diagnosis and it workd ok. but
when i tried it for country is only gives the last country.
although if you open the subreport alone , it gives full.
what could be the problem.

My guess is that the LinkMasterFields and LinkChildFields properties of the
Subreport Control are set to whatever the name of the Field containing
Country, and, therefore, only that record is being displayed. If that is
the case, clearing those properties will eliminate the selection and all the
records will be displayed.

Larry Linson
Microsoft Access MVP