filter on a MS Access table

J

jaybird711

How do I find and edit the filter for an Access (2003) table so I can
rearrange order of sorted fields in the display? When I go to design view, I
cannot find the Filter or query that is the basis for the current sort.
 
J

Jeanette Cunningham

Hi jaybird711,
Open the table in design view and show the properties dialog for the table.
Find the Order By property and delete any text in that property.

Save changes when you are asked.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access query filter problem 1
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Sort / Filter Column Header Arrows Not Visible 3
Access 2003 vs 2010 1
Form filter combo box choices are Is Null/Is Not Null 13
Multiple selection filter - any help appreciated 2
Filter a formula 1
database didn't build the filter 1

Top