Multiple field searches / sorts in Access?

I am compiling an MS-Access database of exterior repairs that are needed in our townhouse complex. To make the data easier to understand, I would like to present the information to the membership by project; i.

Windows Software 5498 This topic was started by ,


data/avatar/default/avatar27.webp

199 Posts
Location -
Joined 2001-03-30
I am compiling an MS-Access database of exterior repairs that are needed in our townhouse complex. To make the data easier to understand, I would like to present the information to the membership by project; i.e...painting, wood replacement, etc....., then by address; i.e...700-A, 715-D, etc.... I have, however, only been able to sort the data by one field at a time. I have been unable to perform multiple-field sorts. Is it possible to do what I am looking to do? Or, should I be using another program like Excel or something else?
 
SnapperOne

Participate on our website and join the conversation

You have already an account on our website? Use the link below to login.
Login
Create a new user account. Registration is free and takes only a few seconds.
Register
This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic


data/avatar/default/avatar33.webp

686 Posts
Location -
Joined 1999-10-28
If you are using a query then you can sort as many columns as you like.
Simply set the "sort by" to whatever you want for which ever field you want.