Re: Creating Monthly Reports in Access
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 17 Jan 2003 09:01:49 -0000
Message-ID: <3e27c67d$0$239$ed9e5944_at_reading.news.pipex.net>
Date: Fri, 17 Jan 2003 09:01:49 -0000
Message-ID: <3e27c67d$0$239$ed9e5944_at_reading.news.pipex.net>
If you use a passthrough query (I.E. Allow Oracle to issue the SQL) then SYSDATE-30 is a day 30 days prior to today. MSAccess can do date arithemetic in a similar way.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "jonb123" <member22828_at_dbforums.com> wrote in message news:2399622.1042749823_at_dbforums.com...Received on Fri Jan 17 2003 - 10:01:49 CET
>
> Hi - can anyone help me to create a report with the time frame of 1
> month back?
>
> In my date field, I currently have to manually set the dates in the
> query like so....
> Between #12/1/02# And #1/1/03#
>
> Is there some kind of code I can input so it will always pull the
> last 30 days?
>
> Many thanks!
>
> --
> Posted via http://dbforums.com