Comparison of Sales figures

  • Thread starter Thread starter Candy
  • Start date Start date
C

Candy

I have a report of quarterly comparisons of sales figures from 2007 and 2008
using group headers for Year, Quarter, Month pulling from a agreement
received date and a Sum of the Cost. I have a column break after the year
section so that the report shows 2007 in the first column and 2008 in the
second column. I want to show a 3rd column with the difference between the 2
years. How can I do this? Do I need to create a subreport of that information?
 
The standard way of checking that is to use :
Datediff("d",[startfield],[endfield]) for days and
Datediff("q",[startfield],[endfield]) for quarters.
You would want to add a textbox to your report (either in the detail footer
or report footer or wherever you need it) and set the Control Source property
(found by right clicking the textbox) and typing:
=datediff("d",[startfield],[endfield]) or
=datediff("q",[startfield],[endfield])
Iff you want both, you will need two textboxes.
 
Thanks for the reply. However I'm looking to compare sales figures,
=Sum([Cost]) from [PrRcvdDate] between 1/1/07 thru 12/31/07 and between
1/1/08 thru 12/31/08. Not sure what the [startfield] and [endfield] should
be? Kinda new at this and hope this isn't a stupid question.

Golfinray said:
The standard way of checking that is to use :
Datediff("d",[startfield],[endfield]) for days and
Datediff("q",[startfield],[endfield]) for quarters.
You would want to add a textbox to your report (either in the detail footer
or report footer or wherever you need it) and set the Control Source property
(found by right clicking the textbox) and typing:
=datediff("d",[startfield],[endfield]) or
=datediff("q",[startfield],[endfield])
Iff you want both, you will need two textboxes.

Candy said:
I have a report of quarterly comparisons of sales figures from 2007 and 2008
using group headers for Year, Quarter, Month pulling from a agreement
received date and a Sum of the Cost. I have a column break after the year
section so that the report shows 2007 in the first column and 2008 in the
second column. I want to show a 3rd column with the difference between the 2
years. How can I do this? Do I need to create a subreport of that information?
Click to expand...
Click to expand...
 
Back
Top