Re: Unwanted alphanumeric sort on time, incorrect min/max value
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Tue, 10 Jun 2008 07:22:10 -0400
Jelle wrote:
LS,
query below is sorted on order and date ascending.
Actually, what I see below is what I assume to be the result of running a
query. It is not the query itself. So ...
Please show us the sql of the query being used to generate this data (you
can clip out the parts we don't need to see - it's the ORDER BY clause i am
interested in). To see the sql, open your query in Design mode, then switch
to SQL View using the View menu or the toolbar button (you can also switch
using the right-click context menu)
The date fields
are, as far as I know real date fields,
"as far as I know"?
I'm not clear why there would be any doubt in your mind, which leads to my
next question:
Is this a local table in your mdb file? or a remote, linked table from
another database? If it is a remote table, please tell us the type and
version of the remote database, as well as the exact data types of the
fields involved. Actually, even if it is a local table, you should open the
table in Design mode and look at the data types (I'm not interested in the
format) of those "date" fields and let us know what they are, for sure.
still, the sort appears to beI will let you know when you have provided the extra information.
alphanumeric, which screws up a min max on the query as well.
Any suggestions??
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
.
- Follow-Ups:
- Prev by Date: Re: Count Problem
- Next by Date: Re: Creating query based on no-match
- Previous by thread: Re: Count Problem
- Next by thread: Re: Unwanted alphanumeric sort on time, incorrect min/max value
- Index(es):
Relevant Pages
|
