Susan Harkins
ssharkins at gmail.com
Fri Sep 5 07:50:30 CDT 2008
And it can be slow if you're dealing with a lot of data. Susan H. > I guess you could and should use DMin without any issues: > > NextItemID = DMin("ID","qryMyFormQuery","[Name] > '" & [Name] & "'") > > It will sort "correctly", that is the default sorting of your database. If > you need any other sorting the plot thickens.