Can I create this...?

[djclntn]

I've come back, but with a totally different database & a different subject. Basically, I have a DateOfBirth (DOB) field which the data type is Date. Within this Table (or in a query) how might I display the ages of the subjects (year of DOB) - the current year?

EG.
Subject Name: John Doe
DOB: 5/3/1968
Age: 43

I'm not sure if this can be done?

[RuralGuy]

Here's the function I use for age:

Public Function Age(DOB As Date) As Integer
   Age = DateDiff("yyyy", DOB, Date) + (Date < DateSerial(Year(Date), Month(DOB), Day(DOB)))
End Function

[orange]

Don't put spaces or special characters in your field names...

Your Table
PersonName
DOB
...

Query

Select PersonName, DateDiff("yyyy",Now(),DOB) as Age from YourTable

Geez.. RuralGuy was answering while I was typing.

[RuralGuy]

Sorry Orange. I didn't know you were typing.

[orange]

It's OK Allan, I didn't realize you were answering.

[djclntn]

Ok,

Just to understand, in my Employees Info Table which has many field; one being an EmployeeID Field (Employees First & Last name abbreviated) & their DOB. Now, do I create an "Age" field in my main Employees Info Table & then do I pull these 3-fields into a query? And when you gave me the "Code" do I put that in SQL & where? I'm sorry for my ignorance & pestering you guys day-after-day; might you be a bit more specific?

[orange]

In your Employees Table, you would have
an Id field autonumber (unique for Access to use)
FirstName text
LastName text
DOB date
any other fields specific to Employee

You would NOT store AGE - it can be calculated at anytime.

You can put Allan's Age function in a query, or in vba if and where needed.

[RuralGuy]

To add to Orange's explaination, I would put the function I supplied in post #2 in a standard module. then in a query of your table I would have "SELECT FirstName, LastName, Age([DOB]) As MyAge FROM YourTable ... etc."

[djclntn]

I'm sorry guys, I'm completely lost!!!

[djclntn]

As everyone knows I'm talking out of my hat, but why wouldn't a DateDiff function work? Clueless I tried, Age: DateDiff(([DOB]-Now()))

You're dealing with an Idiot obliviously...

[djclntn]

<You can put Allan's Age function in a query, or in vba if and where needed>

I don't understand how...? It's sooooooooooooo frustrating!!!

[RuralGuy]

Start by creating a Standard Module and put the Function I supplied in it. Can you do that?

[orange]

As everyone knows I'm talking out of my hat, but why wouldn't a DateDiff function work? Clueless I tried, Age: DateDiff(([DOB]-Now()))

You're dealing with an Idiot obliviously...

This is the syntax for DateDiff

DateDiff("yyyy",Now(),DOB)

http://www.techonthenet.com/access/f...e/datediff.php

[RuralGuy]

What I posted is accurate to the DAY.

[djclntn]

Orange, Please, no offence to anyone else here who spend so much of their time & patience with me; I greatly appreciate ALL of you guys! The DateDiff("yyyy",Now(),DOB) was exactly what I was searching for; you hit the nail on the head! Thanks!!!

One little tweak I would like to make if I can. The numbers are showing as a negative numbers, is there any way the “Age” numbers could be displayed as non-negative Numbers?

For the record, I was only calling myself an idiot out of extreme frustration.

Thanksagain to EVERYONE! :-)