[RESOLVED] How to get Max Record

[MarkT]

A SQL query like this should return what you want.

SELECT     TOP 1 *
FROM         YourTable
ORDER BY [reference number] DESC