Hi,
I have 2 problems partly inter related. In a field (Rev) in a table structure where no actual rev was on the document I picked up from another access app the date. What I would like to do is change that from dd/mm/yy to yyyy (or yy)mmdd as a number.
Then I need to do something a bit weird.
I need to sort on this field so that letters fall below numbers eg. 2, 1, 0, D, C, B, A and then the converted date. The first part is hard enough the second I think near impossible and I may have to resort to a second field in the table for the numerical date.
All help appreciated.
Thanks
Huw
I have 2 problems partly inter related. In a field (Rev) in a table structure where no actual rev was on the document I picked up from another access app the date. What I would like to do is change that from dd/mm/yy to yyyy (or yy)mmdd as a number.
Then I need to do something a bit weird.
I need to sort on this field so that letters fall below numbers eg. 2, 1, 0, D, C, B, A and then the converted date. The first part is hard enough the second I think near impossible and I may have to resort to a second field in the table for the numerical date.
All help appreciated.
Thanks
Huw