viewing records ordered by date
actually i have inserted the "date" in msaccess database table using "dd-mm-yy" format
now i want to view records of that table in ascending order of the date
so i wrote the query:
Select * from TRANSACTIONS order by aco_date ASC,aco_time ASC";
but the problem is if i write this it compares the day first and then the month and then the year since i have inserted the date in dd-mm-yy
but logically it should compare the year first then the month and then the day...hw can i do that?