A ARW New member Local time Today, 20:12 Joined Jun 26, 2005 Messages 6 Dec 23, 2005 #1 Hello all... I have a table which includes month, day & date. I want to sort this table by day, and then by month & then by year... does anyone know how to do this? Thank you...
Hello all... I have a table which includes month, day & date. I want to sort this table by day, and then by month & then by year... does anyone know how to do this? Thank you...
neileg AWF VIP Local time Today, 11:12 Joined Dec 4, 2002 Messages 5,970 Dec 23, 2005 #2 Create a query based on the table. You can apply the sort in the query. Then use the query instead of the table.
Create a query based on the table. You can apply the sort in the query. Then use the query instead of the table.
A ARW New member Local time Today, 20:12 Joined Jun 26, 2005 Messages 6 Dec 24, 2005 #3 ...ok, but I can only order by desc / asc & this wouldn't arrange the data the way I need it, or is there another way to sort month (jan - dec)?
...ok, but I can only order by desc / asc & this wouldn't arrange the data the way I need it, or is there another way to sort month (jan - dec)?
neileg AWF VIP Local time Today, 11:12 Joined Dec 4, 2002 Messages 5,970 Dec 28, 2005 #4 Create calculated fields in your query using datepart() and sort on these calculated fields.
