Report sorted by providers

[missinglinq]

I've been writing apps in Access 2000 for a while now, but never had an occassion to do a "report" report, as it were. Got a report based on a query that sorts out clients by the technician assigned to them, lists the tech and then each client. The problem is, when the client list for a given tech goes over to a second page, the tech isn't listed again. How do I accomplish his?

I know this is probably a simple task, but have never run into it before. Have tried multiple combinations, but never get exactly what I need. Placing the Tech Name in the Page Header and the Tech Name Header does the trick except it lists the tech's name twice on the first page.

Any help or a push in the right direction would be greatly appreciated.

Thanks for your trouble.

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[dhookom]

Set the Tech Name Header sections Repeat Section property to Yes.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[missinglinq]

Thank you, Duane! I knew it had to be something simple. I've just never done this type of report before.

The Missinglinq

There's ALWAYS more than one way to skin a cat!