Hi Mike,
Thanks for this but could you break it down a bit further, also to add to this I want to input a date of birth into one field and output the calculated age into another field.
I have not done any programming in Access before at all so if you could break it down into chunk by chunk...