Report/Query Question.

[Guest]

I need to create a report that lists various information about specific
patents.
I have created a table that stores certain changes that have been made to a
patent record. This 'Archive' table is related to my 'Main' table through
the main table's autonumber ID.

OK so . . .

Each page of my report displays information for only one patent.
Along with showing basic information such as the date of filing, filing
number, patent number, inventor, etc, it also needs to list all of the
changes that have been made over time to that specific patent.

I have created a query whereby my archive has been LEFT JOINED to my main
table. And so if the archive has 3 changes for any one patent, my query
produces that patent 3 times, once for each change. So now when I go to my
report I have a seperate page for each change that has been made to a single
patent. This is my problem.

I need all of the changes for a patent listed on the same page.

I'm really not sure what the best approach is here. I've not had this kind
of problem before. Any help would really be appreciated.

Thanks

 

[John Vinson]

I have created a query whereby my archive has been LEFT JOINED to my main
table. And so if the archive has 3 changes for any one patent, my query
produces that patent 3 times, once for each change. So now when I go to my
report I have a seperate page for each change that has been made to a single
patent. This is my problem.

I need all of the changes for a patent listed on the same page.

Right mouseclick the little square at the upper left of the report in
design view, and select "Sorting and Grouping"; group by the Patent
table's primary key, and choose the option to display the group header
(and perhaps footer).

Put all the patent-specific information on the group header section,
and all the changes information on the Detail section.

John W. Vinson[MVP]
(no longer chatting for now)

 

[Guest]

That works great!

Thanks a lot

Right mouseclick the little square at the upper left of the report in
design view, and select "Sorting and Grouping"; group by the Patent
table's primary key, and choose the option to display the group header
(and perhaps footer).

Put all the patent-specific information on the group header section,
and all the changes information on the Detail section.

John W. Vinson[MVP]
(no longer chatting for now)