hi all,
i have the code below that i think should work but it isn't. there is a problem with the sum command but i just cannot see it. i know that its bound to be something easy but any help appreciated at this late hour
SELECT *, sum(KBI_qty) as gtotal ;
FROM KBI ;
GROUP BY KBI_stkref ;
ORDER BY KBI_stkref ;
INTO temp8
~M
Go raibh maith agat
~M