|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 12th, 2007, 03:54 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Sort by date
I have a report that has information coming in with dates by day. eg February
28, 2007. I am trying to sort in descending order and cannot seem to make it happen. If I sort =month([date by day]) it does the months descending but not the days. Thanks 
|
|
#2
March 12th, 2007, 06:12 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Sort by date
Are you trying to sort by month and then by day?
If so, you can use the Month([date by day]) as the first sort, and then add the second sort Day([date by day]) -- Good Luck BS"D "Arlene" wrote: I have a report that has information coming in with dates by day. eg February 28, 2007. I am trying to sort in descending order and cannot seem to make it happen. If I sort =month([date by day]) it does the months descending but not the days. Thanks
|
|
#3
March 12th, 2007, 10:51 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Sort by date
Thank you never thought to use two sorts
"Ofer Cohen" wrote: Are you trying to sort by month and then by day? If so, you can use the Month([date by day]) as the first sort, and then add the second sort Day([date by day]) -- Good Luck BS"D "Arlene" wrote: I have a report that has information coming in with dates by day. eg February 28, 2007. I am trying to sort in descending order and cannot seem to make it happen. If I sort =month([date by day]) it does the months descending but not the days. Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
