On Sat, 27 Dec 2008 00:06:01 -0800, Will 2823 <Will
I tring to use the date in one field in a database to update another field in
the same database automaticly (Primary date {field 1} – 280 days
=secondary date {field 2}) Please break it down barny style I’m new at this.
Thanks
As Douglas and Pete correctly say, your secondary date field *should simply
not exist* if it can be calculated from the primary date.
To do the calculation in a Query, use the DateAdd function; create a query
based on your table, include whatever fields you want to see, and in a vacant
Field cell type:
SecondaryDate: DateAdd("d", -280, [PrimaryDate])
Suggestion: don't use the default Field1, Field2 fieldnames, use something
meaningful; don't put blanks or special characters in fieldnames, it's allowed
but can be a hassle later; and don't use reserved words such as Date as
fieldnames.