Creating filters in an Access 2007 table

K

Kay

Hi all, here again!! Can someone help me with this please

Question
For the students table filter the data to show only the first 6 records and
save as a query'

Sound simple I know but I have tried every which way that I know, advanced
filter, top predicate, deselecting all the check boxes then selecting the
first 6, adding the filter in table design view, creating a query from the
table - and it still comes back incorrect as does the question

Open the Hospital table, filter the records so it returns the top ten Id's

again I've tried everything and still comes back incorrect

Can anyone help me please
 

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

filtering an access 2007 table 1
Table Preferred width is changed when pasting 1
filtering a table in access 2007 1
Access 2007 filters on forms change the properties 3
Two filters in a pivot table 0
Filtering by group in pivot table 0
connecting table/query filters to forms 1
Slicers and Calculated Items in Pivot Table 2

Top