regression - trend

T

Taher

Hi

I have reports which shows the targets ,goal, baseline etc
for the ongoing project. I have the switch on and switch
off command, which displays various colour light (small
buttons) depending upon the diffrence between baseline and
goal or target. The lights shows colour depending upon the
positive or negative diffrence from target. Currently it
shows only for one month. I want to see what is the trend
from the last 4 or 5 monhts.And depending upon the trend i
could show the arrow going up or down Now to do this i
have to do regression. No can i use regression in access.
If yes then how.

I would appreciate if someone could help me on this.
 
Top