I understand how to perform a "Top" query in Access by using the properties pane.
My question is if there is a different way of doing this where the top n records wasn't a static number but instead, it could be entered in a pop-up box in the same manner as a parameter.
I would love to have the ability to re-run the same Top query, which could be tied to a report, where I would not have to go into the back-end of the query, and manually change the properties pane each time I need a different amount of Top n records to populate my report.
Any suggestions are welcome, and if this is a functionality that simply doesn't exist in Access, please let me know.
My thought is that maybe this could be achieved through a macro, but I'm not very well-versed in macros so I could be completely wrong.