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.

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.

--
KARL DEWEY
Build a little - Test a little


"Kay" wrote:

> 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.