Thread
:
Converting Text months to sortable Numbers or Dates
View Single Post
#
7
CyberTaz
Posts: n/a
No Problem, glad I could Help |:)
On 4/29/05 1:51 PM, in article
, "Greg" wrote:
That works! Sort by month and day using the first key option then by year
using the A/Z button. Cool, thanks!
"CyberTaz" wrote:
BTW- Year doen't have to be to the left... too much Access lately.
Regads |:)
"CyberTaz" wrote:
Hi Greg-
No need to convert... Click in that column, then go to DataSort & click the
Options button. Open the 'First key sort order' list and choose
appropriately, the click OK in each box.
HTH |:)
"Greg" wrote:
I have a column with months as text (April, etc.). Trying to sort them in
order, is there a way to convert them to dates or numbers in order to sort
--
Reply With Quote