Gustav Brock
Gustav at cactus.dk
Thu Dec 2 12:20:49 CST 2004
Hi Pedro Guess you could do something like this: SELECT (CoorX \ 1000) * 1000 + 500 AS CoorX0, (CoorY \ 1000) * 1000 + 500 AS CoorY0, SUM(IIF(FieldA Is Null, 0, FieldA) + ... + IIF(FieldE Is Null, 0, FieldE)) AS Total FROM tblCoor GROUP BY (CoorX \ 1000) * 1000 + 500, (CoorY \ 1000) * 1000 + 500; /gustav >>> pedro at plex.nl 02-12-2004 15:02:23 >>> Hello Group, is it possible to make one sql query for the result below. Without using several query's to come to what is need. It would save me a lot of time. i have CoorX CoorY fieldA fieldB fieldC fieldD fieldE 206210 345120 5 1 2 2 206733 345999 4 2 1 3 207999 345170 1 2 1 207452 345734 1 2 2 i need CoorX CoorY total 206500 345500 20 207500 345500 9