I have done a few different things with dates one was in the design mode of the query under the date colunm I did a <=Now()-90 criteria that returns the records within 90 days of the days date of course you can change the number to suit what you are looking for. I have a couple other expressions in different databases here I will check and see what other ones I have used I hope that is in the direction you are looking and that it helps. I have a few others I will post later when I find them lol !
--- In [email protected], Shae Tal <[EMAIL PROTECTED]> wrote: > > Bill, > > Yes, this is what I am trying to do. > > I am trying to create a trend report for the past 60 days. > > thanks, > shaema > > Bill MacDonald <[EMAIL PROTECTED]> wrote: > 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" <shaetal@> 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 > > > > > > > > [Non-text portions of this message have been removed] >
