Re: Sorting Months

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 08/16/04 

Date: Mon, 16 Aug 2004 18:42:00 -0400

Add a computed field that returns the month number (either the Month
function, or format as mm, not m). Sort on that field, even if you don't
show it on the report. 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Deb" <dmcfer2@state.wy.us> wrote in message
news:73fa01c483de$6e162560$a401280a@phx.gbl...
> I have a date (DateOfApp) which I have formated as "mmmm"
> in a aggregate query for a fiscal summary report (MS
> Access 2000).  Everything works great, grouping by fiscal
> year and month; however, the months sort alphabetically
> instead of by calendar order.  I have checked all the
> usual places and have no sort order set anywhere that I
> can see. Is there an easy way to get the months to sort by
> calendar order?  Am afraid I don't know much VB, but could
> do entries in Design View or SQL.
>
> Thanks much!

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)
  • Re: Multiple date formats in a Table
    ... could choose a future date so they all sort at the end. ... However if you are set up to use UK format dates of dd/mm/yy, ... converting any entries where you know the full date. ... > iii) Once you've got a function that works, create a new query in design ...
    (microsoft.public.access.tablesdbdesign)