only show last 12 records in a subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Database User - 12 Sep 2005 07:46 GMT

I have a database for a fitness club. I made a form with the member details
and then a subform with record of their monthly payments, annual payments
depending on their payment method. But i dont need to be able to see
thousands of records i only want to see the most recent 12 records? How can
this be done?

Reply to this Message

RuralGuy - 12 Sep 2005 13:36 GMT

Assuming you have a way of sorting on "most recent" then "Select Top 12" should
achieve your goals.

>I have a database for a fitness club. I made a form with the member details
>and then a subform with record of their monthly payments, annual payments
>depending on their payment method. But i dont need to be able to see
>thousands of records i only want to see the most recent 12 records? How can
>this be done?

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

Reply to this Message