Filters in MSAccess

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I am in a datasheet view of a table and select a field/vale - I apply a
filter, but the sort sequence of the resulting records changes. What can I do
to apply the filter, but keep the sort order?

Any help is greatly appreciatted
 
CMon said:
When I am in a datasheet view of a table and select a field/vale - I
apply a filter, but the sort sequence of the resulting records
changes. What can I do to apply the filter, but keep the sort order?

Any help is greatly appreciatted
Click to expand...

I would suggest using forms and queries for viewing data. I would also
suggest that tables don't really have a sort order, it is more an accidental
order. It is best to consider tables little more than buckets of data with
a label on the side describing the data types of each field.
 
You must log in or register to reply here.

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

Apply a filter every time data is entered in datasheet view? 9
ADVANCE FILTER SORT WINDOW 1
filter on a MS Access table 1
filtering an access 2007 table 1
Total Row in datasheet view has problems if using ADP / SQL 4
.Filter for multi criteria based filteration. 3
Filter function like Excel 1
Filtering a form with a combo box using left function 4

Back
Top