Month on Month % increase / decrease on report (1 Viewer)

[FrostByte]

Hi,

On my report, I'm looking for what id presume a simple formula that gives me % increase / Decrease of the month on month figures as per the example below…

Jan	100​	0.00%​	Increase
Feb	120​	20.00%​	Increase
Mar	150​	25.00%​	Increase
Apr	90​	-40.00%​	Decrease
May	105​	16.67%​	Increase
Jun	75​	-28.57%​	Decrease
Jul	175​	133.33%​	Increase
Aug	185​	5.71%​	Increase
Sep	125​	-32.43%​	Decrease
Oct	135​	8.00%​	Decrease
Nov	200​	48.15%​	Increase
Dec	210​	5.00%​	Increase
Jan	150​	-28.57%​	Decrease

 

[Ranman256]

I post my data to a 'report' table.
user picks the date range on a form, then queries post the data:

id, currTime, prevTime,currAmt, prevAmt, pctChg

after the data has posted for each time range, 1 more update query runs to post the PctChg.

 

[arnelgp]

add an autonumber field to your table:

see Query1 on the sample.

 

[FrostByte]

add an autonumber field to your table:

see Query1 on the sample.

This looks really promising. Really appreciate both replies. I'll keep you posted on progress.