Share via

Loading Filter/Sort From Query - Access 2016

Anonymous
2018-05-01T21:41:33+00:00

I have made a query that filters and sorts a table. If I double-click that saved query, it opens the table freshly filtered/sorted. I do notwant to do this. I want to open the table (unfiltered) and click Hometab > click Advanced under filters > click Load from Query...; however, the **Load from Query...**is currently dimmed and not available. Why is this? How can I fix it?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,775 Reputation points Volunteer Moderator
    2018-05-01T22:13:22+00:00

    If you run a query it is NOT opening the table, its is opening the query based on the table with your sorting/filtering.

    If you want to open a table unfiltered, then open the table directly. then open the query if you want the sorting or filtering.

    Or you use a form to display the table in datasheet mode, then apply filters and sorts through the form.

    0 comments