View Full Version : last record


junmart
10-23-2001, 08:22 AM
how do i get the value of the last record in my field? thanks in advance.

Jack Cowley
10-23-2001, 02:29 PM
Amazing what you can find in Access Help:

"If you want to return the first or last record in a set of records (a domain), you should create a query sorted as either ascending or descending and set the TopValues property to 1."

[This message has been edited by Jack Cowley (edited 10-23-2001).]