Not sure what you mean. are you trying to query dates that fall 60 days back from the current date? In a field? I am doing a lot of work right now on queries to find dates that fall in specific criteria let me know if this is the direction you are going in I may be able to add a little help
Bill -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of rmillson2001 Sent: Tuesday, May 13, 2008 10:30 PM To: [email protected] Subject: [ms_access] Re: Set Column 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 > ------------------------------------ Yahoo! Groups Links
