finding the how old is she/he with queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I HAVE A DATA BASE THAT HAS THE BIRTHDATE OF MY EMPLOYEES. I WANT TO RUN A
QUERY THAT TELLS ME HOW OLD EACH PERSON IS...I HAVE BUILT THE QUERY 'LAST
NAME, FIRST NAME, BIRTHDATE' AND USED EXPRESSION BUILDER LIKE SO: =SUM
([EMPLOYEES]![BIRTHDATE]-[DATE ()]
NO GOOD... HELP PLEASE I AM LOST AND CONFUSED.
 
I HAVE A DATA BASE THAT HAS THE BIRTHDATE OF MY EMPLOYEES. I WANT TO RUN A
QUERY THAT TELLS ME HOW OLD EACH PERSON IS...I HAVE BUILT THE QUERY 'LAST
NAME, FIRST NAME, BIRTHDATE' AND USED EXPRESSION BUILDER LIKE SO: =SUM
([EMPLOYEES]![BIRTHDATE]-[DATE ()]
NO GOOD... HELP PLEASE I AM LOST AND CONFUSED.
Click to expand...

Posting in newsgroups using all caps is considered shouting. Please
post using regular type.

The following expression will determine a persons age:
In a query:
Age: DateDiff("yyyy", [Birthdate], Date()) - IIF(Format([Birthdate],
"mmdd") > Format(Date(), "mmdd"), 1, 0)
 
Oh please excuse me. I did not mean to shout.
Thank you so very very much. The expression is perfect and works to give me
exactly what I need. thank you again. :-)

fredg said:
I HAVE A DATA BASE THAT HAS THE BIRTHDATE OF MY EMPLOYEES. I WANT TO RUN A
QUERY THAT TELLS ME HOW OLD EACH PERSON IS...I HAVE BUILT THE QUERY 'LAST
NAME, FIRST NAME, BIRTHDATE' AND USED EXPRESSION BUILDER LIKE SO: =SUM
([EMPLOYEES]![BIRTHDATE]-[DATE ()]
NO GOOD... HELP PLEASE I AM LOST AND CONFUSED.
Click to expand...

Posting in newsgroups using all caps is considered shouting. Please
post using regular type.

The following expression will determine a persons age:
In a query:
Age: DateDiff("yyyy", [Birthdate], Date()) - IIF(Format([Birthdate],
"mmdd") > Format(Date(), "mmdd"), 1, 0)
Click to expand...
 
Back
Top