Sort Date and hour

[Peter D]

I have a table and 2 items are date and hour

I made a query to sort them, i sorted on date and hour but only the
date is sorted

So 12/12/06 12:12 came after 12/12/06 18:00 in my query result.

What went wrong????

Tx anyone

 

[Wolfgang Kais]

Hello Peter.

I have a table and 2 items are date and hour.
I made a query to sort them, i sorted on date and hour but only the
date is sorted.
So 12/12/06 12:12 came after 12/12/06 18:00 in my query result.
What went wrong????

How did you sort????
Did you use the design grid or the properties window? Or both?
Did you sort in ascending or descending order?
Another idea: Maybe the date portions of the hour values differ?

 

[Van T. Dinh]

Please post the SQL String of your query.

 

[Larry Linson]

I have a table and 2 items are date and hour

Do you mean that you have two separate Fields, one for data, and the other
for time? If so, you should re-consider and use a single Date/Time Field to
contain both date and time. That's the way Access is intended to work.

I made a query to sort them, i sorted on date
and hour but only the date is sorted

So 12/12/06 12:12 came after 12/12/06 18:00 in my query result.

What went wrong????

Post your query and perhaps someone can offer a useful suggestion.

Larry Linson
Microsoft Access MVP