Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2011
    Posts
    9

    Question Unanswered: Filter By Date In Different Fields

    Hi,

    I have the following fields:

    Name (text)

    Date of Payment 1 (date)
    Paid 1? (yes/no)

    Date of Payment 2 (date)
    Paid 2? (yes/no)

    Date of Payment 3 (date)
    Paid 3? (yes/no)

    Date of Payment 4 (date)
    Paid 4? (yes/no)

    I want to create a query that will show me the names with "Date of Payment" of a week ago and that is not paid yet (so, not marked on the yes/no field).
    So I open the query and I will see where date of payment is today until 7 days ago.
    If the field Paid is marked, do not show.

    The problem is that when I create this criteria for Date of Payment 1 and Paid 1, the program ignores Date of Payment 2. If Paid 1 is marked it doesn't show anything. But if Paid 1 is marked, the program should use the criteria for Date of Payment 2 and Paid 2, until everything is paid. So it's an OR criteria not AND.

    How do I do this?

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    I'm confused here. Posting the query as you have it now would help to understand the problem.
    Have a nice day!

  3. #3
    Join Date
    Feb 2011
    Posts
    9

    Post

    I just want a table to control who paid on time and who didn't.

    So I have registered the date of payment (the date when the person needs to pay) and I will check if the payment occur, if Yes I check the box, If no I uncheck the box.

    Next month, same thing, for the same person, since it's more than 1 payment.
    If all the boxes of this person is checked, this person shouldn't appear in the query, because he already paid everything.

  4. #4
    Join Date
    Feb 2011
    Posts
    9
    I will normalize the data.

Posting Permissions

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