Multiple field searches / sorts in Access?
This is a discussion about Multiple field searches / sorts in Access? in the Windows Software category; 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.
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
SnapperOne
Participate in our website and join the conversation
This subject has been archived. New comments and votes cannot be submitted.
Responses to this topic
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.
Simply set the "sort by" to whatever you want for which ever field you want.
