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