Dear All

I have a table having a column of Date of Birth. another column named Date of Retirement. Now I want to create an update query that fills the column date of retirement by adding 60 in year of Date of Birth.

I have 1200 record in my table so I want to fill it by query.

Please help me.

Thanks.


Wasim

Wasim,

Generally speaking, it is a bad idea to store derived values in a database table. If the retirement date is always at the employee's 60th birthday, and if you already store the birth date, then the best practice is to not store the retirement date, and instead calculate it on demand.

Also, it is a bad idea to put spaces in field names (or table, query, form, or report names, for that matter).

If you still want to do this:

UPDATE YourTable
SET [Date Of Retirement] = DateAdd("y", 60, [Date Of Birth])