Compatible Support Forums: Multiple field searches / sorts in Access?

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Multiple field searches / sorts in Access?

#1 User is offline   SnapperOne 

  • member
  • Group: Members
  • Posts: 199
  • Joined: 30-March 01

Posted 13 May 2003 - 04:35 AM

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
0

#2 User is offline   felix 

  • addict
  • Group: Members
  • Posts: 691
  • Joined: 28-October 99

Posted 13 May 2003 - 05:48 AM

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.
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users