Field format for ages

C

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
 
K

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.
 

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

Format for number field 4
Excel Ages formatting - Excel 0
Number format help needed please 8
Calculating age differences 6
putting peoples' ages in age groups...? 2
Return a value if variable is in a range 3
From Date of Birth Select records inbetween ages 3
Total clients ages by year 5

Top