my Date query

[carl024]

i face some problem in date query detail is

table1
work_name=repairing
start_date =01-jan-2000
duration_year= 01

if duration_year= 01
in query auto display finish_date= 01-jan-2001

work_name=repairing
start_date =01-jan-2000
duration_year= 01
finish_date= 01-jan-2001

i wait answer

 

[Kiwiman]

Howzit

Use the datead function in your query

Date_Finish:DateAdd("yyyy",[table1]![duration_year],[table1]![start_date])

 

[carl024]

Thank you sir it is very nice