age calculation using field date of birth by query

  • Thread starter B Panneer Selvam
  • Start date
B

B Panneer Selvam

1.calculating the current age using date birth field by access query. 2 nd
how can I seperate the Name field (full name ) in to two name field like
First name and last name using query.
3.Please provide me the web site address or various functions formula tips
with example that can be useful to create database more effective. Thank you.
B.Panneer Selvam.
 
D

Douglas J. Steele

1. See http://www.mvps.org/access/datetime/date0001.htm at "The Acces Web"
for how to calculate Age.

2. Separating names isn't as trivial as it may sound. You can use
Left([FullName], InStr([FullName], " ") - 1) and Mid([FullName],
InStr([FullName], " ") + 1) to handle most of them, but what are you going
to do with names like Billy Bob Thornton or names like Cher? Unfortunately,
you usually need USB (Use Someone's Brain)

3. A little too broad a question. Take a look at all of the stuff that's at
"The Access Web" site I cited above. Another good list of resources can be
found at Jeff Conrad's
http://www.accessmvp.com/JConrad/accessjunkie/resources.html
 

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

Calculating age from date of birth and ignoring if blank 5
date of birth age formula 8
Date of Birth 4
Query: calc. age based on birth date 1
computing age 1
"how do I calculate age by using date of birth details" 5
Calculating a person's age 2
Sort members by age on particular date 4

Top