Results 1 to 3 of 3
  1. #1
    nevets is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2012
    Posts
    5

    Limit report to a range of dates


    I have created a query that has a field "DateClosed" and from that field I have created another field that calculates a date 30 days out. The problem I have is that it pulls all of the records. Is there a way to limit the records to ones that were closed between a start date and end date?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Sure, several ways. You can use a parameter query or use this technique:

    BaldyWeb wherecondition

    With either I'd use a form to let the user enter the dates; you have more control that way.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    irish634 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    48
    You can also do this in your query criteria "where condition"
    "Between [Start Date] And [End Date]"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Query input dates for range of dates in two fields
    By kagoodwin13 in forum Queries
    Replies: 3
    Last Post: 02-13-2012, 04:25 PM
  2. Limit Report to top 5
    By Nathan Plemons in forum Reports
    Replies: 1
    Last Post: 01-26-2012, 10:55 AM
  3. Replies: 13
    Last Post: 09-27-2010, 03:10 PM
  4. Replies: 3
    Last Post: 09-29-2009, 07:08 AM
  5. Count Dates within Date Range
    By eckert1961 in forum Queries
    Replies: 2
    Last Post: 03-08-2009, 10:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums