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
|
|||
|
|||
year to year comparison
i need to create a report that shows orders received, YTD, for current year
and last year, same time, and show percenage incr or decr. How do i isolate last years data? (ie 01/01/04 - 03/11/04)? i have a report set up to handle this year based on a dialog box " enter weekending date?". it is the rest of the query i am having trouble with. |
#2
|
|||
|
|||
"steverizzo" wrote in message ... i need to create a report that shows orders received, YTD, for current year and last year, same time, and show percenage incr or decr. How do i isolate last years data? (ie 01/01/04 - 03/11/04)? steverizzo, Just use those same dates above instead of this year's dates. i have a report set up to handle this year based on a dialog box " enter weekending date?". it is the rest of Change to " enter last year's weekending date?". Sincerely, Chris O. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Getting Fiscal Year instead of Calendar Year | Keena | Setting Up & Running Reports | 1 | October 1st, 2004 02:55 PM |
Show last year first, but keep data sorted cronologically | Bob Richardson | General Discussion | 11 | July 22nd, 2004 10:00 PM |
Add a FIXED MONTH and DAY with the CURRENT YEAR | texcel | General Discussion | 1 | June 23rd, 2004 01:36 AM |
date conversion | web_time | Worksheet Functions | 10 | December 25th, 2003 06:51 PM |