Sort By Address and Surname

[Olafgarten]

Hi, okay i have a database of people and i need to do some sorting in a report. it's quite hard to explain but i'll try.

i want to sort by surname but group families by address. for example:

Surname Address
Aaa 123 Test Town
Aaa 123 Test Town
Bbb 123 Test Town

Ccc 453 Example Drive
Ccc 453 Example Drive

so i want it to go to the first surname, find it's family by address and list it's family.
then go to the next record and do the same

 

[dhookom]

You should have asked in the reports forum. However it looks like you could sort/group first by address and then sort by surname.

Duane
Hook'D on Access
MS Access MVP

 

[hermanlaksko]

Your could do this in the recordset for this report.

Select * From YourAddresses Order By Surname, Address

Herman
Say no to macros

 

[dhookom]

Herman,
I assume you are referring to the report's Record Source rather than Recordset. I never rely on the sort order in the record source as it is always ignored when there is Sorting and Grouping used in the report design.

Duane
Hook'D on Access
MS Access MVP