Does anyone know if a filter could be added to a form which is based on a Top query in Access 2002?
I'm fairly new to filtering by form but for my current project here at work it's proving to be particularly useful.
My user would like to be able to browse a subset of records in the form based on being the top 10 of a particular numberic field within it. I can get the filter to work if I put > 'whatever' in the criteria, but it doesn't seem to respond to a 'Select Top 10 ...' in the SQL.
I'm fairly new to filtering by form but for my current project here at work it's proving to be particularly useful.
My user would like to be able to browse a subset of records in the form based on being the top 10 of a particular numberic field within it. I can get the filter to work if I put > 'whatever' in the criteria, but it doesn't seem to respond to a 'Select Top 10 ...' in the SQL.
