G Guest Apr 19, 2004 #1 How would I code a query to retrieve only the last 20 records of a specific person?
P Peter van der Goes Apr 19, 2004 #2 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.
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.
