Filtering by Form with a Top Query

[Cads]

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

 

[mp9]

Did you remember to add an "ORDER BY..." as well as a "TOP 10" to your SQL. Check out

http://www22.brinkster.com/accessory/queries/004/shtml

for more syntax help on this.

 

[Cads]

Sure did! Thanks anyway.

I did try your link but Internet Explorer came back with an HTTP 404 page - 'The page cannot be found'. Also tried to look at variations on the address but no joy. Is the site still active?

 

[marsss]

http://www22.brinkster.com/accessory/queries/004.shtml