Results 1 to 1 of 1
  1. #1
    relliott is offline Novice
    Windows Vista Access 2003
    Join Date
    Jul 2009
    Posts
    4

    Date issue: Pulling data based on dates parameters of other table

    Ok, so here is the issue. I have two tables, BillingPeriods and Receipts.



    My billingperiod table has several dates that I want to represent as A cutoff date of my billing period. What I want is to have the query show only Reciept of Payments that have occured from the current Date to the day after the last cut off date in order to pull the current reciepts for the bill month.

    I will post some of the table data to help a little more.

    Table: BillingPeriods

    CutOffDate
    1/15/2009
    2/26/2009
    4/9/2009
    5/14/2009
    7/2/2009
    8/13/2009
    9/24/2009
    11/5/2009

    Table: Receipts

    RecieptBy(column 1)
    Bill
    Bill
    Joe
    Bill
    Ryan
    Doug
    Mike
    Joe
    Bill
    Adam

    RecieptDate(column2):
    06/20/2009
    06/23/2009
    06/26/2009
    07/22/2009
    07/20/2009
    07/21/2009
    07/23/2009
    07/24/2009
    07/25/2009
    07/26/2009


    So the query build would include reciepts from 7/3/2009 to today, 7/27/2009.

    I want it to be auto-updateable for next month. so that as soon as 8/14/2009 comes the query will be blank until reciepts start being entered.

    I hope there is an answer to this problem. Thank you for the help in advance.
    Last edited by relliott; 07-27-2009 at 08:00 AM. Reason: Reformatting Table data

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

Similar Threads

  1. Need help with date issue.
    By ITChevyUSSNY in forum Reports
    Replies: 13
    Last Post: 02-05-2013, 10:06 AM
  2. Count Dates within Date Range
    By eckert1961 in forum Queries
    Replies: 2
    Last Post: 03-08-2009, 10:58 AM
  3. Pulling most recent data from child table
    By davidv43 in forum Access
    Replies: 0
    Last Post: 02-07-2009, 11:36 AM
  4. Replies: 3
    Last Post: 10-23-2008, 08:43 AM
  5. Having trouble with dates in my Data Base!!!!
    By BigPhil in forum Queries
    Replies: 4
    Last Post: 02-15-2006, 12:47 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