Hey guys,
New to the forums but ive hit a snag whilst updating a Access Database at work.
Currently trying to repair and maintain a database that has been built by 6 people all with even worse knowledge of access then me and its becoming a pain at least.
My boss has just said that she wants a new field that displays the date of the patients 55th Birthday.
Problem is there are 1500+ records on this database and ive had a play around but couldnt find out how to do what i wanted to do, so i thought id come to the experts.
As i said i have 1500 patients on this database and i need to calculate their 55th birthday from their DOB
So i need to somehow:
Pull info from the fields in the DOB column
Add 55 to the year section in a dd/mm/yyyy format
and output it to the 55 Birthday column.
I want to be able to do this simultaneously across the 1500 patients, and then once thats done i want it to be on the database so when i enter a new patients DOB it automatically calculates their 55th birthday.
Hope this is clear enough, any help would be greatful. Im working on limited time due to incompetent manager expectations and i dont really want to spend the time going through 1500 records and calculating the 55th birthday manually.
Thanks in advance guys
- Nixeh