Want the query to figure a future date

[diesel]

I have a table containing three fields, LastName, FirstName, AdmitDate. I
want to write a query that will figure the HPDate which is the AdmitDate plus
3 days.

 

[Banana]

In query builder, put this in a column:

HPDate: DateAdd("d", 3, [AdmitDate])

 

[diesel]

I guess I am confused. When I do this it asked for a start date. If I leave
it blank it doesn't figure anything. I just want it to figure the dates
automatically.
--
diesel

In query builder, put this in a column:

HPDate: DateAdd("d", 3, [AdmitDate])

I have a table containing three fields, LastName, FirstName, AdmitDate. I
want to write a query that will figure the HPDate which is the AdmitDate plus
3 days.

 

[John W. Vinson]

I guess I am confused. When I do this it asked for a start date. If I leave
it blank it doesn't figure anything. I just want it to figure the dates
automatically.
--

From... what? Today's date? If so replace [Admit Date] with Date().