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 ?
