Member Headings

  • Thread starter Thread starter Carter
  • Start date Start date
C

Carter

Hey all...

I have a simple database that keeps the contact
information for individuals. Each individual belongs to a
certain "Oraganization". This is specified by an options
group on the form (e.g. group 1, group2, etc.).

How do I set up the report so that it will print off all
the names but separated by group.

GROUP 1
John Doe
Jane Doe

Group 2
Dan Doe
Dennis Doe

Any help would be appreciated.

C
 
-----Original Message-----
Hey all...

I have a simple database that keeps the contact
information for individuals. Each individual belongs to
Click to expand...
a
certain "Oraganization". This is specified by an options
group on the form (e.g. group 1, group2, etc.).

How do I set up the report so that it will print off all
the names but separated by group.

GROUP 1
John Doe
Jane Doe

Group 2
Dan Doe
Dennis Doe

Any help would be appreciated.

C
.
Click to expand...
On report design view, go to View/Sorting and Grouping.
Select the field you would like to group on and
reassemble the controls if necessary.

Jesse Avilés
(e-mail address removed)
http://home.coqui.net/monk
 
I have a simple database that keeps
the contact information for individuals.
Each individual belongs to a certain
"Oraganization". This is specified by
an options group on the form (e.g. group
1, group2, etc.).

How do I set up the report so that it
will print off all the names but separa-
ted by group?
Click to expand...

"Options group on the Form" doesn't have anything to do with the
Report... the Report uses as its RecordSource information in a Table
or Query... unless, as I will assume, the Group/Organization
information is stored along with the individual's information when the
Record is stored from that Form.

In that case, in the upper-leftmost corner of the Report, right-click
and choose Sorting and Grouping from the popup menu that appears. Use
your Group or Organization information as a Group -- you'll be able to
specify whether to create a Group header or footer, or both.

Followups and clarifications should be here in the newsgroup, not by
e-mail. Thanks.

Larry Linson
Microsoft MVP
 
Back
Top