Subreport Math/Date Comparison

[Guest]

I have a report that list employees and their salary history. I also have a
subreport that list wages earned by year which prints in the page footer in
decending order.

2006 $53922.37
2005 $52296.96
2004 $45943.11
2003 $43381.20

I would like to add two columns. One for the dollar amount increase and
another for the percentage of increase over the prior year so that my report
looks like:

2006 $53922.37 $1625.41 3.1% INCREASE
2005 $52296.96 $6353.85 13.8% INCREASE
2004 $45943.11 $2561.91 5.58% INCREASE
2003 $43381.20

Any help would be appreciated

 

[Larry Linson]

You have a Subreport Control, in which a Report is embedded -- in design
view, click the control to select it, right-click and select "Properties",
then look at the Source Object to determine what is embedded. The embedded
Report will have a RecordSource that retrieves the data. Add the Fields you
want to the RecordSource, if they are not already included, and place
Controls (probably TextBoxes) to display them on the Report.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks for the speedy reply. My subreport is based on a query with that has
the name, payroll number, date, wages for each weekly check for each
employee. The report adds all the earnings (in summary) for each person for
each year of employment. I guess I don't quite understand your answer. I
don't know where to put the two fields I need or how to make the report do
the math. Can you explain it in another way?
bobbye