filtering a table in access 2007

K

Kay

I'm still having problems with this filtering in a table. I'm not a student
with homework, I am a tutor updating my skills to 2007. I am trying to teach
myself at home but I do have exams soon. I am really foxed with this one.
It asks - Filter the students table to show ID's up to 6
The format of the ID's is 00001, 00002 etc and the ID is the primary key
I've tried advanced filter, I've tried the equals to and between and less
than criteria but it still keeps saying fail. It could be this software I've
got, it had a blip with the excel module -kept failing me but I got 88% in
exam!!
If anyone has got any ideas at all I would be very very grateful.
 
K

KARL DEWEY

If you used Between 0 and 6 on 00001 and 00002, which are not numerical
values, using math caiteria will not work. They are text strings and must
have approproiate criteria.
Between "0" And "00006" will work.
 

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
Access 2007 looses actual increment high value 4
Filtering a table does not work 5
Access 2007 DLOOKUP 26
Newbee 12
Access 2007: Creation date of objects and filter question 2
Import - subsequent table split - maintaining relationship 7
Access 2007 Filter by Form 3

Top