You might be able to adapt this solution of a Running Sum in a Query: http://support.microsoft.com/kb/290136
--- In [email protected], "shaetal" <[EMAIL PROTECTED]> wrote: > > Hello, > > Does anybody have idea on how to set a column value to Now and move > back 60 days. > > Eg I want the rows values as 05/13/2008, 05/12/2008, 05/11/2008... > 03/12/2008. > > I know how to set it to Now but don't know how to set a query to set up > a column that will go about 60 days back. > > any help is appreciated. > > thanks, > shaema >
