Date Function

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I am running a query from a table that limits the output of data to a
specific time frame. I am working on the last month minus 12 months. So
what I want to see is from April of this year to May of last year. This is
progressive as the months change. i have been using:

Between (DateAdd("m",-1,Date())) And (DateAdd("m",-12,Date()))

This gives me this years May which I do not want.

Any help would be appreciated

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • RE: How to combine existing collections to include or exclude...
    ... Servers you want minus the ones you don't want ... Add computers you don't want to show up in Collection B ... When you refresh you will have a new collection with A, computers minus the ... will see if I can't just send you the collection queries and the query ...
    (microsoft.public.sms.admin)
  • Re: Has anybody tried to make a navigation like Google?
    ... you can use whatever estimation mechanism you like to get the total instead of a second query ... "keyColumnName", """Column name used to count total number of columns""", ...
    (comp.lang.python)
  • RE: Using a time frame, now asks for it even for design view
    ... Jet rewrites the SQL code any time the query is ... You may want to go over the SQL with a fine toothed ... possibly recreating the queries from scratch will fix the ... > I never sorted or filtered using the time frame (unless, by filtering, you ...
    (microsoft.public.access.queries)
  • Re: Large DataSet Question
    ... This limits the number of rows returned. ... This posting is provided "AS IS" with no warranties, and confers no rights. ... > The query that the user is running is using LIKE which can return a large> datset of records based on the "LIKE" value passed in. ... >> William Vaughn ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: [PHP] More info on timeout problem
    ... ; Resource Limits; ... upload limit and has no problems with large files getting to it. ... timeout problem at first, and assumed that the varying load on the ... Then see if you get the complete query you expect. ...
    (php.general)