I need the last 20 records of a specific individual

P

Peter van der Goes

Deacon said:
How would I code a query to retrieve only the last 20 records of a
Click to expand...
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.
 
Top