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.
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,