Calculating Formulate for dates

[Guest]

I am creating a student attendance table:
Start date Field 05/01/2004. I wish to create a formulae in the table that will automatically calculate 7 days from the start date and insert the calculated date in the Week2Date Field.

Can this be done in the design view of the table? Any suggestions of the simplest method(s) on how it can be achieved would be greatly appreciated.

Mike K

 

[Tim Ferguson]

I wish to create a formulae in the table that will automatically
calculate 7 days from the start date and insert the calculated date in
the Week2Date Field.

No you don't.

You want to create a query that will display the calculated date: put this
in the top line of a new query grid:

WeekTwoDate: DateAdd("w",1, [StartDate])

Hope that helps


Tim F