Order it by the date itself, not by the Format()'d date. Rob
T tony Aug 7, 2006 #2 hi. i want to group by date field and display it in format of dd/mm/yyyy. the problem is when i use the order by Format([dateCreate],"dd/mm/yyyy"), its not order by real date. any solution for that ?
hi. i want to group by date field and display it in format of dd/mm/yyyy. the problem is when i use the order by Format([dateCreate],"dd/mm/yyyy"), its not order by real date. any solution for that ?
