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!
Recent content by Matga
-
Calculate Year over Year Change
PHV, I took a look at self join and got it to work. Thanks for pointing me in the right direction!- Matga
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Calculate Year over Year Change
PH, I was able to calculate the change using multiple crosstab queries that create a separate column for each year. However, this is very inefficient as it requires a separate query for each data column, and I have many data columns. I would like to do it all in one query. I don't have a clue...- Matga
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Calculate Year over Year Change
I have a database of 36 months for 50 hotels with many columns of operational data. I want to calculate percent change in the Data1 column from 2002 to 2003 and from 2003 to 2004 for every month and put it in a column on the same query. A complication is that every month I get a new textfile...- Matga
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
