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" <[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
[Non-text portions of this message have been removed]
