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:

ZONE _01/05/04 __02/05/04 _03/05/04 _____TOTAL
BS_________30 ________30 ________0 ________60
DL_________45 _________0 ________0 ________45
UB_________22 _________0 ________0 ________22
DR__________0 _________0 ________0 _________0
FE__________0 _________3 ________0 _________3
FL__________0 _________5 ________0 _________5
D1__________0 _________0 ________6 _________6

but I'm only at this stage so far:

DAY ______ZONE ____VAL
01/05/04 ____BS ___30
01/05/04 ____DL ___45
01/06/04 ____UB ___22
02/05/04 ____BS ___30
02/06/04 ____DL ____0
02/06/04 ____DR ____0
02/06/04 ____FE ____3
02/06/04 ____FL ____5
03/05/04 ____BS ____0
03/05/04 ____D1 ____6

I used this statement to get the above:

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
FROM DATA_LOG1
WHERE (((Mid([DATA_LOG1].[point_id],21,4))="SHFT"))
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...!

Thanks in anticipation,
Bicen