>>Is there a way to select the last record of a table with only a select statement?
>
>The answers you have gotten (... where recno() = reccount()) should work, but a GO BOTTOM is probably faster, especially for a large table.
My sentiments exactly.
Imagination is more important than knowledge