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
|
|||
|
|||
how do I get my reports to list in day order vs. year order?
I've created a birthday report which works great except that my birthdates
for each month are in order by year. I need them in order by day. The dates are inputted in medium date format which is used to calculate individual ages. I'd just like to see them in order of day the birthdays will happen. Any ideas? Thanks in advance. Jeff |
#2
|
|||
|
|||
how do I get my reports to list in day order vs. year order?
If your Birthday date field were named BDate, place Month(BDate) in the
first row of the report's Sorting and Grouping dialog box, and Day(BDate) in the second row. That will force all the BDates to list in ascending order by Month and Day. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "JacCeeBee" wrote in message ... I've created a birthday report which works great except that my birthdates for each month are in order by year. I need them in order by day. The dates are inputted in medium date format which is used to calculate individual ages. I'd just like to see them in order of day the birthdays will happen. Any ideas? Thanks in advance. Jeff |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a list in sequential order | Mark Jackson | Worksheet Functions | 6 | November 7th, 2005 11:08 PM |
E-mail Display name is wrong | Jane Nangle | Contacts | 9 | February 4th, 2005 10:05 AM |
want other value in query and report | GI Smith | New Users | 10 | January 5th, 2005 02:03 AM |
synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |
date conversion | web_time | Worksheet Functions | 10 | December 25th, 2003 06:51 PM |