Results 1 to 7 of 7

Thread: Access (2007)

  1. #1
    New Lounger
    Join Date
    Feb 2008
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access (2007)

    As a new Access user I have a question. I have a current Query that I am working on. I pull information everyday, then I send it to a table that I keep building upon. I would like to set up a revolving 30 day view , but the past information will not be lost. Does anyone know how I can accomplish this.....Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access (2007)

    Welcome to Woody's Lounge!

    I'm not certain I understand exactly what you want, but you could create a query with the following condition in the Criteria line for the relevant date field:

    Between Date()-30 And Date()

    This will select all records for the last 30 days.

  3. #3
    New Lounger
    Join Date
    Feb 2008
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access (2007)

    ok, that seemed to change some thing around.That looks good. Now in the ( ), I want to be able to add the current date automatically, so that every day this date will change. Then everyday I can run this quesry and it would go back the 30 days.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access (2007)

    Date() returns the current date, so whenever you run the query, it will return the records for the last 30 days at that moment.

  5. #5
    New Lounger
    Join Date
    Feb 2008
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access (2007)

    ah, Thanks. Thats the reason why it worked so well. ....So my 30 day view work great. Now, since I started gathering info from the begining of this year. Is there a way that I can have that info availble to myself at all times going forward. Both views on the same sheet??

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access (2007)

    You could create two forms: one based on a query that displays all records, and another based on a query that displays only the last month.
    You can place these two forms side by side or one above the other as subforms on an otherwise empty main form. The main form would be unbound, i.e. its Record Source property is blank.

  7. #7
    New Lounger
    Join Date
    Feb 2008
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access (2007)

    I got it!....Thanks for the help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •