report based on 2 order by fields 1

[Lightningfast]

I need to create a report list for an art show. List needs to have exhibit numbers in order grouped by artists so that they can be easily found from catalog. Trick is I only want to print the artists name when it changes. eg Joe Bloggs then list Joes exhibits in numerical order access wants to change every time the exhibit number changes

 

[PHV]

Have a look at Group

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dhookom]

Or the "Hide Duplicates" property of text boxes.

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]