Field format for ages

[Corinne]

I have a database in which I need to store the reading
ages of pupils in school. I then need to be able to find,
for example all those with a reading age of less than 10.
I also need to record those that have reading ages 'not
available' and some will have an age that is 11+ or 6-
and the plus and minus signs need to be recorded. Could
anybody tell me what format to use. At the moment I am
using text but then I can't use a query to find those
that are <10.

Thank you

 

[Ken Snell]

Use text.

To find the numbers less than ten (for that matter, any number), simply use
Val function (or, if you have the + and - signs at end, CDbl function) in a
calculated field to convert the text to a number and then filter based on
the calculated field.