How to sort by date correctly?

[Kevin3NF]

Is the date column defined as date/time or text?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/Newsgroups

 

[Lynn Trapp]

Is your field a date/time field or a text field?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp

 

[Kiyeon]

When I sort by date in ascending order, it goes by the first digit, not by
the year so it doesn't sort them correctly.
For example, record 02/11/1998 is above record 11/04/1978
How do I fix this? Thanks.

 

[Kevin3NF]

deja-vu?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/Newsgroups

 

[Karen Skipper]

i was thinking something like
"great minds think alike"

 

[John Vinson]

deja-vu?

Hey, Kevin... give him a break! You posted about two minutes before he
did... (and if I hadn't been watching, I'd have posted the same
question!)

 

[Kevin3NF]

Lynn is a friend of mine....he knows I'm just playing with him....(I
think/hope)

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/Newsgroups

 

[Lynn Trapp]

Yeah, but you beat me to it all over again

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp

 

[Lynn Trapp]

I wonder how many others were about to pounce on that one?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp

 

[Lynn Trapp]

Not to worry, Kevin. I definitely knew you were pulling my leg. You can let
go now. Kevin... Kevin... KEVIN ;-)

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp

 

[Fred Boer]

Hey, everybody! I see there's a "no license" question still available
further down... Race you!! <g>

Fred Boer

P.S. Kevin: I laughed loudly when I saw your munged email address. My
children heard me. They looked over my shoulder....Now I have to explain
it.... thanks a lot!!

 

[Kevin3NF]

I could change it to:

khill@NoIDontNeedViagraOrAMortgageRefinanceOrHotYoungGirlsFromAsiaYouWackoSp
ammer3nf-inc.com

but that takes forever to type...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com

 

[John Vinson]

Lynn is a friend of mine....he knows I'm just playing with him....(I
think/hope)

Oh, I know. Sorry I didn't put a smiley on that since I was just
playing along with both of you!

 

[Kiyeon]

It's "text" type. Thanks

Is the date column defined as date/time or text?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/Newsgroups

 

[Kiyeon]

It's "text" type. Thanks.

Is your field a date/time field or a text field?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp

 

[John Vinson]

It's "text" type. Thanks

So it's sorting correctly. The text string "11/04/1893" is
alphanumerically larger than the text string "03/21/2003". Access has
no way of knowing that you intend this Text field to be interpreted as
a date!

Put in a calculated field in your query, CDate([fieldname]), and sort
on it.

 

[Lynn Trapp]

I could change it to:

khill@NoIDontNeedViagraOrAMortgageRefinanceOrHotYoungGirlsFromAsiaYouWackoSp
ammer3nf-inc.com

but that takes forever to type...

Cut and Paste! ;-)

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp