Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006
    Posts
    43

    Unanswered: Payments Made Between two dates

    I would hoping that I could get some help with this question:

    I'm working two dates that will highlight the accounts that have made a payment Today (Last Payment) + 60 days & move the entire row to another tab

    Payment Made: iff ([Date of Last Pay])>60 days from ([Dis Date) highlight and move to tab number 2
    and
    Payment Made60: iff ([Date ()])>60 days highlight and move to tab number 3

    Thank you so much for your help

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    496
    Provided Answers: 24
    Not sure what you mean by TABS. In a form? Query sets don't have tabs.

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Im quessing the reference to tabs is that the OP is using the same form, as a sub form, but on different tabs of a parnet form. if so 'just' set a filter on the sub forms in each tab.

    or perhaps better yet have a single subform with, say, a radio button group to display all rows that have made a payment, paid with n///days, or as many optiosn as you need.
    stylistically you may be better off having a list, or combo box, box as these are all the same type of option and may get overly complex if say you have to add lots of these sort of date options. radio buttons are grerat for say 3...5 options.
    use a check box for an either or choice (eg either show invoices outstanding, or all invoices)
    use a list or combo box if say there are 5 or more options (depends on your screen size and so on), and also if there is a risk that the list of options may need to change over time. a list box can be set up so that users can add their own custom values, and if dersigned properly from day one require no further development time.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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