year to year comparison

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
steverizzo said:
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)?
Click to expand...

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
Click to expand...
rest of

Change to " enter last year's weekending date?".


Sincerely,

Chris O.
 
Back
Top