When I use order by on a acces text field that contains numbers the order does't appear to be working.
Is this because the text are numbers. Heres my code.
.RecordSource = "select * from [Family History] where [Family #] ='" & FamilyNum & "' order by [Order Number] desc"
SHouldn't this arrange the records in descending order via the order number?