Report HELP ME!!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with several subforms one of the subforms is a notes form that
contains several records for each record in the main form.

I want to create a report that displays certain fields from the main
form/main table and all of the notes from subform/note table in the same
section without having to display the main fields several times.

I have a parameter query that pulls the data based on dates if I include the
notes fields on the query it pulls the record a separate time for each note
and thus creates multiple entries for each record. This is what I am trying
to avoid in the report. Any help would be great.
 
SarahJ said:
I have a form with several subforms one of the subforms is a notes form
that
contains several records for each record in the main form.

I want to create a report that displays certain fields from the main
form/main table and all of the notes from subform/note table in the same
section without having to display the main fields several times.

I have a parameter query that pulls the data based on dates if I include
the
notes fields on the query it pulls the record a separate time for each
note
and thus creates multiple entries for each record. This is what I am
trying
to avoid in the report. Any help would be great.
Click to expand...

Group your report on the date, and you can place the "main table" fields
into the report's group header and they will only appear once. Leave the
notes in the report's Detail section.

Carl Rapson
 
Back
Top