Reduce multiple entries on reports from Access DB

  • Thread starter Reduce multiple entries for same person
  • Start date
R

Reduce multiple entries for same person

I have linked two databases and one of them contains multiple entries (its a
log of the individuals actions) for the same individual. I am trying to
create a report that lists the person, info about them, and then all the log
information on them. What is happening is that the report will create a new
page for each entry. So I end up with like 20 pages for the same person,
rather than a main page with their info and a page or two with the log
information. How can I set this up so that I can run a concise report?
 
L

Larry Linson

Please describe the tables and/or queries that are the RecordSource for your
Report.

This might be a good fit with a main report for person and a subreport
control with a report of that person's log information.

Or, you could likely accomplish the same thing with a single query, using
the report's "sorting and grouping" properties. That is group on Person, put
the person's information in the Group Header, then put the log information
in the Detail Section.

Larry Linson
Microsoft Access MVP
"Reduce multiple entries for same person" <Reduce multiple entries for same
[email protected]> wrote in message
news:[email protected]...
 
Top