filtering an access 2007 table

K

Kay

In a pre test paper I am asked to 'create a filter that only shows the first
6 records of a table'
I have tried every mothod I know, Advanced Filter, changing the property in
the table, clicking the filter button in the Datasheet - deselcting all -
then selcting the first 6 record. But it keeps saying I've failed the
question. Anybosy got any ideads please?????
 
J

John Spencer

Take a look at the TOP predicate.

And to ensure you are getting only 6 records, make sure your sort
includes the primary key of the table.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating filters in an Access 2007 table 0
filtering a table in access 2007 1
Access 2007 query (large IN statement), alternate approaches 8
Filter/Search button not working in Access 2007 0
Generic filtering system 0
Access 2007 filters on forms change the properties 3
Filter and Search button not work in Access 2007 5
question on Access 2007 datasheet filter 1

Top