Group Together
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.
|