Re: Table Sorting

From: Doug Robbins (dkr_at_NOmvpsSPAM.org)
Date: 02/15/05 

Date: Mon, 14 Feb 2005 21:27:08 -0500

Maybe the entries in the "Date" column are not in a format that is
recognised as a date. What format are they in? Send me a copy of the
document if you wish. 

-- 
Please respond to the Newsgroup for the benefit of others who may be 
interested.   Questions sent directly to me will only be answered on a paid 
consulting basis.
Hope this helps,
Doug Robbins - Word MVP
"Melissa needing help!!" <Melissaneedinghelp@discussions.microsoft.com> 
wrote in message news:8A7223D9-B085-4D11-8EC3-F235208FC29D@microsoft.com...
> Yes, I'm able to sort the first column, but not the second.
>
> "Doug Robbins" wrote:
>
>> Are you saying that you could not use the "Then by" controls in the Sort
>> dialog?
>>
>> -- 
>> Please respond to the Newsgroup for the benefit of others who may be
>> interested.   Questions sent directly to me will only be answered on a 
>> paid
>> consulting basis.
>>
>> Hope this helps,
>> Doug Robbins - Word MVP
>> "Melissa needing help!!" <Melissaneedinghelp@discussions.microsoft.com>
>> wrote in message 
>> news:3C63180E-455A-402C-88B9-9EDB2207DB43@microsoft.com...
>> >I have a table with four columns, the first column is Event the second 
>> >is
>> > Date, I want to sort the columns by Event than by date, I  went to the
>> > sort
>> > menu and it will sort the Event but not the date, how do I sort both
>> > columns.
>> >
>> > Thanks a million!
>>
>>
>>

Relevant Pages

  • Re: Completely baffled on what should be simple
    ... the same thing I previously did, changing format to custom ... sort, it didn't work. ... if a cell contains the text ...
    (microsoft.public.excel.misc)
  • Re: Completely baffled on what should be simple
    ... And remember just changing the format of the cell won't change the underlying ... sort, it didn't work. ... for the extensions that have either one or two 0's as the first numbers, ...
    (microsoft.public.excel.misc)
  • Re: Sane Syntax
    ... It's sort of like a game of telephone - if converting ... I don't know much about DocBook, but tsy's "Super DocBook" format does ... capability for visual markup, ... material before it was typeset. ...
    (comp.text.tex)
  • Re: Sort order - Data midified / Created
    ... What you suggest is a kludge to get around a Windows flaw. ... on the sub heading "Change the date, time, or number format" On the Formats ... All I do is click on the column header and the sort happens, ...
    (microsoft.public.windows.vista.general)
  • B-Tree Index Usage
    ... to write programs using/abusing an editor instead of the proper programming ... By the way my latest testing indicates that a Sort will not use a date index ... interpretation betwwen ACCESS and a program. ... to get the proper format the program DM,BP, DATE will still give one the ...
    (comp.databases.pick)