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

Hi Jeff,

the age field can hold 4 characters, 3 numerals (1-100) and either h,d,w, or m., dependent on the input age. I input the age into the age field, e.g., age 45 this is subtracted from 1901 = 1856 (which is entered into the year born field). If a child is, let's say 8 months, then I enter [space][space]8m. When 8m is subtracted from 1901, I would like it show 1901 in the year born field.

Regards

Jeff