I need the last 20 records of a specific individual

[Guest]

How would I code a query to retrieve only the last 20 records of a specific person?

 

[Peter van der Goes]

How would I code a query to retrieve only the last 20 records of a

specific person?

You can use something like this:

SELECT TOP 3 * FROM tblTransactions ORDER BY fldTransactionDate;

which returns the three rows with the earliest transaction dates. Adapt to
your table and field names.