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().

 

[KenSheridan via AccessMonster.com]

It should work. Switch to SQL view and paste the following in place of
whatever is there, substituting your real table name in place of 'MyTable'.

SELECT [FirstName], [LastName], [AdmitDate],
DateAdd("d", 3, [AdmitDate]) AS HPDate
FROM [MyTable];

Ken Sheridan
Stafford, England

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.

In query builder, put this in a column:

[quoted text clipped - 3 lines]