I've tried all kinds of combinations of selecting the top 10 with a count query but can't seem to get the 10 records to be anything but the last 10 inserted. <BR><BR>Not being a strong SQL guy ...

An SQL query is typically tailored to retrieve the ... Dates or ID columns work best. If it’s the row count you want, another approach is to obtain row-count statistics from the system table.

The Count function helps you easily create a query that, based on any criteria, sums up the number of Access records you have. Here's how to use it. The Count function helps you easily create a ...