queries Dates come out in alphabetical order not in Chronological

T

techwiz101

when I run a quary the dates months come out in Alphabetical order insted of
chronological order, its even so on the report derived from the queries. how
can i Get it back in Chronological order.....
 
R

Rick Brandt

techwiz101 said:
when I run a quary the dates months come out in Alphabetical order
insted of chronological order, its even so on the report derived from
the queries. how can i Get it back in Chronological order.....
Click to expand...

Somewhere between the table where the dates are stored and where you are
seeing them sort wrong they are being converted to strings. Two common
reasons would be use of the Format() function or the Nz() function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get tweets in chronological order? 2
arranging dates in chronological order 3
Troble generating query in with its Dates in Chrnological order 2
Sorting by Month field in simple query 4
Sorting by month field 1
Reverse chronological order 3
date format/sort problem 5
First function returning min 4

Top