Date Sort

[T.Reisz]

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?

 

[Jeff Boyce]

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...

 

[T.Reisz]

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?

----

 

[Brendan Reynolds]

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]

Thank you for your gracious response. Actually, you helped quite a bit. I
went back into the design (which I had been taking for granted) and found the
glitch I'd been trying to work around.