Help with a complicated report

[Loki2303]

Hi all, new to this forum but thought I would shout out for a bit of help with a complicated report I am trying to create.

Bit of background, I work in the financial industry and need to make a statement/transaction listing for one of our clients.

It is a bit complicated in that there are multiple spenders under each group and I want the report to show the data in the following format:

"spender 1"
Transaction 1
Transaction 2
Transaction 3

"spender 2
Transaction 1
Transaction 2
Transaction 3

So on and so forth, is this possible, I was thinking of usin a loop expression within the reports section?

Any help would be greatly appreciated, thank you.

 

[dhookom]

You don't have to worry about loops. Just set the record source to a query or SQL statement and then use the built in sorting and grouping to handle the order records are displayed.

Duane
Hook'D on Access
MS Access MVP