I need to know if there is an equivalent to the first() function that is used in MS Access.

Sorry, I am not very familiar with MS Access, but SQL has such thing:
http://www.csis.gvsu.edu/GeneralInfo...5a.htm#1129681
It's the FIRST() function.

standard SQL does not have this as I know. But there are certain delicts provided by dabase vendors to get the first one. This depends on the database you are using.

I have no knowledege on this topic. But I did find a thread on another forum.

http://www.tek-tips.com/gviewthread....184/qid/646291

You might also want to try using a either, TOP, MIN(), MAX(), and/or a combination of the functions.

MIN() and MAX() are called aggrigate operations and it is intended to return the minimum value or the maximum value of a certain field, but not the first or the last. TOP is available to restrict the number of records selected from the query, say TOP 10 will only return the first 10 rows.

Cheers,
Suren.