Hi guys, I'm trying to generate Access reports here using linked Oracle tables. (The tables are completely unrelational and almost all the data is in one column which I have to slice and dice. The db design is out of my control.)
I'm attempting to get a matrix-style result set like this:
SELECT DISTINCT Format(DATA_LOG1.timestamp,"dd/mm/yyyy") AS [Day], Mid(DATA_LOG1.point_id,1,2) AS [Zone], Sum(DATA_LOG1.[_VAL]) AS SumOf_VAL
GROUP BY Format(DATA_LOG1.timestamp,"dd/mm/yyyy"), Mid(DATA_LOG1.point_id,1,2);
Any help with any of this would be appreciated...!