Applying a filter

[Prayder]

I just created a table where the primary key field is labeled hour and goes from 6a to 6am. But when I close it and reopen it, the column starts at 10a and not 6a. I have to click on the toggle filter button on the ribbon in order for it to change back to the way I had it. Is there a way to keep that from happening so that every time it is opened it shows starting the column with 6a?

 

[AlexHedley]

You could create a Query instead.
Save this and open that instead of your Table.
It's best to work with Queries instead of Tables if you want do filters etc.
Sometimes the filtering on a Table doesn't persist.

Create a new Query, add your Filter, in the Ribbon in the Sort & Filter Section select Advanced then Advanced Filter/Sort...

You can then Save that Query + Filter as it's own Query.

You can learn more about Queries from
Access Beginner Level 1