DLast

[DS]

I'm using this DLast statement for a field with these values...
1, 1A, 1B etc...
I'm tryimg to get the alpha part. I need to know what the last letter
used is, this only returning the number part. Any help appreciated. Thanks
DS

Me.Txt1 = DLast("CheckName", "Sales", "CheckName ='" & Me.Txt2 & "' and
Paid=False")

 

[Douglas J Steele]

DLast is actually a pretty useless operator: "Last" only has meaning when
the sort order of the underlying records is known, and you cannot know what
the order of records in a table is.

Try using DMax instead.

 

[DS]

DLast is actually a pretty useless operator: "Last" only has meaning when
the sort order of the underlying records is known, and you cannot know what
the order of records in a table is.

Try using DMax instead.

Thanks, That worked!
DS