Grlouping records in reports

  • Thread starter Thread starter Hansel L Haycox
  • Start date Start date
H

Hansel L Haycox

I am working on a data base with 4 linked files. I have
combined these files into a query and am using this query
as a basis for the report. I want to search the query to
find information on a particular individual, then display
the results in a report.

Ideally, I will come up with the individuals name etc,
and then will have the records from the other 3 files
grouped together, but can't seem to do it.

The report I have visualized is like this:

This report pertains to John Doe.
Records from data file 1 are:
Data File 1 Record 1
Data File 1 Record 2
Data File 1 Record 3
Data File 2 Record 1
Data File 2 Record 2
Data File 2 Record 3
Data File 3 Record 1

Any help anyone can give about how to sort or group the
records so that they all records from one file will
appear in a group would be deeply appreciated.

Hansel L Haycox
 
I'd think the simplest approach to grouping the Records as you want would be
to put in a Subreport Control for each Table containing a Report of the
information from that Table, using the LinkMasterFields and LinkChildFields
properties of the Subreport Control to synchronize. You wouldn't then need
the multi-joined Query that you describe... a simpler Query for the main
Report, and a simple Query or direct Table reference for each Subreport.

Larry Linson
Microsoft Access MVP
 
Back
Top