G
Guest
How would I code a query to retrieve only the last 20 records of a specific person?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peter van der Goes
specific person?Deacon said:How would I code a query to retrieve only the last 20 records of a
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.