Counting from a Date

[Tippingtim]

Hi I am relatively new to access hence the question?



Is it possible to make one column automatically count 21 days from the date of another column, and if so how?

[Bob Fitz]

I don't know about A2007 or A2010 but upto and including A2003 I don't think that is possible when viewing data directly using the table.
It can be done using a form bound to the table.
Add an unbound textbox to the form and use the DateAdd() function in an expression as it's Record Source property.