SELECT Table.Value
FROM Table
ORDER BY Table.DateEntered DESC
[code]
Now that gets you all of them sorted by their date from most recent on, but not just the last 10
you might be able to do
[code]
SELECT Table.Value, Count(Table.Value) AS count
FROM Table
WHERE count < 10
ORDER BY Table.DateEntered DESC
[code]
But I'm not sure if that'll work or not. Access doesn't support ROWCOUNT so I'm not sure if the only 10 records is an option.