Results 1 to 4 of 4
  1. #1
    insixt is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    6

    A query that shows records from now until the end of the month...


    I'm doing a database that records jobs to be completed.

    I want to be able to see what jobs are due for this month, what jobs are due next month and what jobs are due two months from now (seperate query for each of these). I need it to work forever and thus can't use set dates.

    How would I go about doing this, I know I should use 'now' somewhere in the filter term but I don't know the rest!

    Please help!

  2. #2
    MAF4Fam6's Avatar
    MAF4Fam6 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Location
    Fruit Heights, Utah USA
    Posts
    140

    Setting Date Range Using Parameter Query

    You can have your query ask you to input the parameters yourself everytime you run your query (parameter query) in which the user interactively specifies one or more criteria values as the query runs.
    1. Open query in design view
    2. Enter the following data in the Criteria row underneath your start date field:

    Code:
    >=[Enter the start date for this range] And <=[Enter the end date for this range]
    Hope this helps.

    RC
    Fruit Heights, Utah

  3. #3
    insixt is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    6
    Thanks for your reply! Is there a way I can have the parameter set automatically to toda (whatever today might be), so that I only have to enter the end date range?

  4. #4
    MAF4Fam6's Avatar
    MAF4Fam6 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Location
    Fruit Heights, Utah USA
    Posts
    140

    Setting Date Range Using Parameter Query

    Use the following criteria instead:
    Code:
    >=Date() And <=[Enter the end date for this range]
    Thanks.

    RC
    Fruit Heights, Utah

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

Similar Threads

  1. Report based on query shows no data
    By hbograd in forum Reports
    Replies: 2
    Last Post: 12-18-2009, 12:28 PM
  2. Simple Report by Month
    By leejqs in forum Reports
    Replies: 3
    Last Post: 07-15-2009, 09:24 AM
  3. All Access Objects shows nothing
    By Viwadd in forum Access
    Replies: 5
    Last Post: 05-29-2009, 02:23 PM
  4. SQL Query by day to end of month
    By tcasey in forum Queries
    Replies: 0
    Last Post: 10-07-2008, 09:55 PM
  5. Replies: 2
    Last Post: 07-24-2006, 09:19 PM

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