One Record at a time Report - Access 2007

[WSR]

I have a table with columns that represent different metrics on separate
investments.

Each investment is a separate row of the table.

Is it possible to have a Report based on the table that displays/prints each
row as a separate report?

Thanks!

(B^>)-]=[

 

[Marshall Barton]

I have a table with columns that represent different metrics on separate
investments.

Each investment is a separate row of the table.

Is it possible to have a Report based on the table that displays/prints each
row as a separate report?

Well, lots ot things are possible, but in this case it can
be a pain. Why not just start each detail on a new page (or
group on the investment ID and start each group on a new
page)?

If you really have to have separate reports, then you need
to open a recordset on the report's data, loop through it,
open the report filtered on the ID field, wait for the
report to close, and then go on to the next record.

 

[WSR]

Thanks for your reply!

That would be the solution if I knew how to do it.

So when I go into Report Layout Tools/Format/Group and Sort/click the "More"
arrow at the bottom.

What would be your instruction to have each investment print on a separate
page?

"do not keep group together on one page"
"keep whole group together on one page"
"keep header and first record together on first page"?

This is difficult to explain but you got the gist of what I'm trying to do!

Thanks again!

(B^>)-]=[