Dartcoach/anyone, this is my problem and it is leading to me probably having to launch the laptop out of the first floor window... I have a table named members, two of the fields are DATE OF BIRTH and AGE. with everyones help i have managed to automatically show the age once the DOB has been entered(into the Members FORM). The problem is that the result(the AGE) is not showing in the table, the AGE on the table is showing blank but all the other members details are showing. This also means that i cannot create an enquiry involving age, becuase it is not registering the number in the table. HELP!!!

Satts,
Remember, you don't want to store the age! It is a field that should be recalculated everytime you need it, because it may have changed since the last time.

You can create a query, because the same calculation you use in your form, can be used in a query.

dartcoach

Sorry mate. Ive got you now!!!! Where abouts on the Querie do I input the expression? How do i get the Querie to look at the Forms Age? I appologise if i am sounding a right thickie!

Satts,
I'm working on it.

Give me an hour or so.

dartcoach

Satts,

Paste this as a column on your query:

Expr1: DateDiff("yyyy",[BirthDate],Date())+CInt(DateSerial(Year(Date()),Month([BirthDate]),Day([BirthDate]))>Date())

Use the criteria to get only the ages you want.

You can thank the individual on your previous post for the code, I just tested it.

dartcoach

Mate, is this going to allow me to look for eg. members under the age of 18???

Yes. In the criteria section under the above code, put < 18

it will give you everyone on your table who's age is less than 18

dartcoach

I have pasted that expression in the query column and it asks me to enter parameter value??????????????? This is doing my head in!!! Do you reckon i will get the hang of this!!!???

which value is it asking for?

Dartcoach, you have done it mate. This time it really has worked!!!!!!!!!! cheers mate.