Sorting a Report by more than 10 fields 1

[Timko]

I have created a report and I want to sort on 13 fields, but in the Sorting and Grouping dialog there are only 10 rows. I cannot find a way to include more rows so that I can sort by more than 10 different rows.

I hope that some one can help me.

Tim

 

[dhookom]

A single sorting and grouping level can contain an expression the includes more than one field. You can also consider using subreports to increase the number of levels.

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]

 

[Timko]

Hi dhookom

Thanks for your reply, but i'm not sure how I can include an expression which sorts by more than one field. I have tried entering an expression "order by (country, ID, Value) but it won't accept this.

Could you let me know how I can do this?

Thank you

Tim

 

[dhookom]

If you wanted to sort by LastName and then FirstName in a report, you could set the sorting and grouping expression to something like:
=Left([LastName] & Space(40),40) & [FirstName]


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]