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
Setting column width in a table with a macro is not working 0
Access 2003 vs 2010 1
Dealing with a Pivot Table (when I don't want to) 0
Access 2002 change report header text 0
Cannot sort a table containing text 5
QBF & Query Malfunction 0
Create a chart from a table in word thats dynamic 0

Top