MS Access Query--Display only first (top) record set
Posted on 2014-09-14
I have an Access Query ("Querry1"). Record-sets within this Query are automatically sorted by the 'Last Field that was Modified' so the Record-set containing the last field that was updated will always appear first (at the top) in my Query.
I only want the Query to display this first (top) Record-set (I do not want any other Record-sets to be displayed). Does anyone have an idea how to do this?
I'm not great with Access, so if you could walk me though each step it would be most appreciated.