Report question?

[deercreek]

I have a report question if anyone could help. I have a query that I
want to drive a report. The query can have multiple lines of
information driven by an id field. When I make my report I would like
to be able to show everything on one page. Also I want to be able to
show certain column headings only once like name for instance, but
other fields I would like to show the multiple lines of information I
have. Is this Possible?

[Steve]

Keeping everything on one page may not be possible, depending on how
much data you have.

For the rest of it, you'll want to investigate grouping options. The
Sorting and Grouping dialog can be shown by opening your report and
going to View > Sorting and Grouping. You can add fields to group on (I
would recommend grouping on your ID field, and below that another group
where your name field and other column headings will sit).

Fields with multiple lines of information per ID should be placed in
the Detail section. Column headings should go in the section you've
deigned for that purpose (see parenthetical statement in above
paragraph). Note that you can select groups, and they have properties.
One thing you might want to take a look at is the group property "Keep
Together" which can be set to Yes or No.

[deercreek]

I cant figure out anyway to get that to work.

[Steve]

Have you gone to View>Sorting and Grouping?

If you want assistance, you're going to have to give more information
than that you can't get it to work.