Bill,
thanks for the response. I think i am looking for something different than
what you have.
I am looking to populate a column with date values from Now() to 60 days back
and these
values are not coming from the database and then I have summary data that is
coming out of the database.
I am thinking of doing an union query to run the query for each day seperately
or
populate a table daily that will give me the Now date for that day and then
do trending
based on that data.
shaema
Bill <[EMAIL PROTECTED]> wrote:
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]
>
[Non-text portions of this message have been removed]
