an easy one still to be solved

[emanuele]

Hi guys, I just delivered to my company my first database of which I am very proud since I did not know what access was until one month ago. I got a big big book at the library and succesfully created My "Bonus System". Now The problem is: I created a report that shows to each club member how many points he collected. It works perfectly but I would like only the last 10 last transactions to be showed on it, Just like the memo we get from a bank machine teller. Any suggestions?

 

[WayneRyan]

emanuele,

Base your report on a query:

Select Top 10
Field1, Field2, Field3
From YourTable
Order by TheDate DESC;

hth,
Wayne