Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how to calculate yearly trends in access
Thanks to all of you for your help, I used the statement above and it gave me the correct result. Thanks- Blerta
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
how to calculate yearly trends in access
Hi, Please can anyone help me with this issue? I have a variable(Revenues) and revenues over 4 years in 4 fields(rev_01,rev_02,rev_03 and rev_04) I want to calculate the yearly trend(rev_02-rev_01)/rev_01. Till now everything is easy but the problem is that my data are in this way: Rev_01 Rev_02...- Blerta
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
