Search results for query: *

I also faced some problems and tried to close some quotes but eventually couldn't solve the last one. See here: http://www.corobori.com/sos/picCrossTab.jpg Jean-Luc www.corobori.com

Hi, I tried the one given by gol4 as I liked the fact of doing in one query. Am I right to say that there is a problem as it seems to divide by the value of the current year instead of the previous year ?

SELECT CLng([Table].[Year]) AS [Year], Table.EmployeeID, Sum(Table.Amount) AS SumOfAmount FROM Table GROUP BY CLng([Table].[Year]), Table.EmployeeID; Somebody suggested me the following and it works: save this query (in my case QRY1) now you can use this query SELECT QRY1.Year...

Say a table with the following fields showing salary and benefits Year EmployeedId ItemId Amount Containing the following records 1999; 1; 1; 52000 1999; 1; 2; 1000 2000; 1; 1; 50000 2000; 1; 2; 1000 2000; 1; 3; 1000 2001; 1; 1; 60000 2001; 1; 2; 2000 2002; 1; 1; 69000 2002; 1; 2...

Robert, You made my day ! Great idea, it work's just fine. For those who wants to use it be aware that with print preview you have to let the query modified for printing otherwise it won't work. I just change Robert's code to use only the select part of the query in there was already a WHERE...