Access sort and filter - dynamic

[Mkunanets]

Is there a way I can sort by ascending and filter to only show the top criteria. Meaning the criteria is dynamic. But I always want to show the top. The record count is also dynamic. So for example I have the following data
Q12020
Q12020
Q12021
Q42020
Q32020

so I would want to only show the Q12021 and it’s respective data going forward. And the. When the dates change I would want to show the more recent quarter. Again both the criteria and record count is dynamic.
Any help is really appreciated!!

 

[Trevor G]

Use a query to show the results. if the date period Quarter One is the results your after then that would be the criteria, if you want it more dynamic you could use a form with a combo showing the quarter period and then link that to the query to show the results. Criteria on this field would be Q12021.

 

[xenou]

since these values are not sortable as is you would need to sort with a little extra logic,
something like order by right(value, 4) desc, left(value, 2) desc
that would bring the most recent to the top.

But also as noted above it would be useful to use an input or a query to get just the most recent quarter, then use that value as a criteria for your next step (results for that quarter).