# Percent of change on report...Is this possible?

#### lmac

##### Board Regular
I have a report that shows totals for the month from daily entries (report is based on simple query based on data entry table). I want to add a Percent of Change field to the report that shows the % of change in the Total Sales Per Hour from month to month. Is this possible?

Report has:
.......Total Hours....Total Sales....Sales per Hour....SPH % Change
Aug.....500.............4210...............8.42..................NA
Sept....750.............5900...............7.87..................-6.57%
Oct......800.............6680...............8.35..................6.14%
Nov......825.............7200...............8.73..................4.52%

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### SydneyGeek

##### MrExcel MVP
You may find it simpler to do this in Excel.
In a new workbook, use MS Query to pull the data from Access into the worksheet. In the first blank column, build the formula to get what you need.
Reason for the suggestion: Access is not great at comparing 2 records (rows). I guess you could try to get fancy with a DLOOKUP to pull the previous value, then compare them, but that could be a pain.

Denis

#### lmac

##### Board Regular
Still seeking help for this. This is an Excel spreadsheet I am making into an Access report. Anyone else have any suggestions on how to do this?

#### SydneyGeek

##### MrExcel MVP
If it's already in Excel, consider doing the calc there and importing into Access. Alternatively, why not report in Excel anyway -- unless you have a whole pile of other data in the db that you want to include.

As I mentioned before, you can pull in data from the previous record but it involves either
(1) using a DLOOKUP function or
(2) writing the values to a field in your table, using code

As far as I know, there is no simple control or switch that can create the comparison in a report, unless you have already grabedd / modified the data using one of the above approaches.

Denis

Replies
0
Views
905
Replies
8
Views
300
Replies
2
Views
446
Replies
0
Views
1K

1,195,743
Messages
6,011,395
Members
441,612
Latest member
npasha1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back