Re: Date Sort

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Brendan Reynolds (brenreyn)
Date: 11/11/04 

Date: Thu, 11 Nov 2004 12:15:16 -0000

The reason that we are having difficulty understanding your question is that
we are not aware of any 'problem of sorting dates'. What problem are you
experiencing when sorting on dates?

I'm afraid I can't help with the expression builder, I haven't used it for
quite a long time now. To the best of my memory, I don't think I ever found
it very useful, even when I was starting out. Of course, your mileage may
vary. 

-- 
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
"T.Reisz" <T.Reisz@discussions.microsoft.com> wrote in message 
news:B9C56280-7757-4162-B1BF-4F50F74DA3B4@microsoft.com...
> 1.  I have been using DateValues from Excel as one of the fields of my 
> Access
> db
> to be able to sort accurately on its matching date (in the adjoining 
> field).
> 2. I'm sure the Expression Builder in Design View would be able to handle
> this problem of SORTING DATES.
> 3.  None of my books go into detail as to how to use EXPRESSION BUILDER.
> 4. Has anyone solved the problem Of SORTING ON DATES using EXPRESSION 
> BUILDER?
> 5. Can anyone recommend a BOOK thAt describes in detail how to use the
> features of EXPRESSION BUILDER?
>
> How's that?
>
> ----
> "Jeff Boyce" wrote:
>
>> What "matching" -- matching with what?
>>
>> What problem?  Your subject line mentions sorting, your description 
>> mentions
>> matching, and no problem is described.
>>
>> Are you gettiong error messages?  We aren't there, so we need a more
>> detailed description...
>>
>> -- 
>> More info, please ...
>>
>> Jeff Boyce
>> <Access MVP>
>>
>> "T.Reisz" <T.Reisz@discussions.microsoft.com> wrote in message
>> news:B5A88074-76E1-4983-BB2E-5FDE33FCBF11@microsoft.com...
>> > I have been using DateValues from Excel in one of the fields of my 
>> > Access
>> db
>> > to be able to sort accurately on its matching date.  I'm sure the
>> Expression
>> > Builder would be able to handle this problem, but none of my books go 
>> > into
>> > detail as to how to use it. Has anyone solved this problem?
>>
>>

Relevant Pages

  • Re: Date Sort
    ... went back into the design and found the ... > we are not aware of any 'problem of sorting dates'. ... > GlobalSign digital certificate is a forgery and should be deleted without ... >> features of EXPRESSION BUILDER? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Order of files with cp
    ... Apparently this "sorting optimization" in `cp' goes all the way ... any urgent reason to fix it immediately. ... entries just so files are copied before directories? ...
    (freebsd-current)
  • Re: Splitting the genres
    ... :: allegedly sorts the books by size. ... title (but before sorting by spine color). ... : of the normal shelves. ... And then there are those books which are ...
    (rec.arts.sf.written)
  • Re: Cheap Bookshelves
    ... My domestic partner just bought a bunch of books at auction. ... She wants to set up shelves and sort from the boxes onto ... Once all the sorting is done, the stuff that gets integrated into her ... Bearing all this in mind, what are your suggestions for the shelving? ...
    (rec.collecting.books)
  • Re: CRIT: The Spammers F.A.Q.
    ... Zeborah wrote: ... amenable to reason, it's just that they get defensive too quickly and ... then the flame war gets in the way of sorting things out. ...
    (rec.arts.sf.composition)