Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    122

    Unanswered: Help creating text box that displays last 3 payments

    I am trying to create a text box on a continuous subform that would display the last 3 payments made to a company. I am currently displaying the subform as a datasheet and would like to simply add another field that would display the payments like Date/Amount, Date/Amount, Date/Amount. Any help would be greatly appreciated.

  2. #2
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    You are wanting like 6 different text boxes to display an amount and date of the last 3 payments? Are you familiar with DLookup? You may want to investigate that and see if it can possibly help you. You probably can use the primary key somehow (If it is a number) to tell which are the three most recent records.

    I dont know exactly how to instruct you or which direction to guide you in. I hope somthing I have said will help,
    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Stick this in your rowsource:

    SELECT TOP 3 date, amount
    FROM yourTable
    ORDER BY date DESC
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Sep 2003
    Posts
    122
    How do I display those three records in one text box?

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Oh, I'm sorry. I read to fast and assumed you were using a combo box.

    Create a recordset with the SQL listed above, then iterate through each record and append it to the .value property of your text box.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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