Hi Karl,

Thank you very much for your response. I got it figured out. I just have
to make some changes in the Page Setup under the File menu.

Thanks again.

"KARL DEWEY" wrote:

Sorry, crosstab will not do it.
--
KARL DEWEY
Build a little - Test a little


"KARL DEWEY" wrote:

Use a crosstab query.
--
KARL DEWEY
Build a little - Test a little


"AccessHelp" wrote:

Hello all,

I have a report containing 2 sub-reports. One is to show a list of book IDs
that are checked out today, and the other one is a list of book IDs that are
checked in today. Currently, the book ID text box is in the Book ID Header
section. The report does list a listing book IDs checked out and in, but it
does not show it as tabulate format. It lists the book IDs under one column.
I want to list them under multiple columns.

Can it be done? Please help.

Thanks.