Thread: Date query
View Single Post
  #1  
Old June 2nd, 2010, 08:55 PM posted to microsoft.public.access.forms
SeeAll
external usenet poster
 
Posts: 25
Default Date query

Hi,

I am using a census database to enter data from the 1901 UK census. To calculate the year born the input age is subtracted from 1901. However, when a child under one year old is enter, obviously an error shows.

What do I need to do to show 1901 when a child's age under one year is entered. The age field can hold three numbers and one letter (h = hours, d=days, w=weeks, m=months) if needed, eg., 5, 100, 5w.

Regards

Jeff