Finally get to try this and I still have some problems. if I use the following code everyting works fine.
SELECT U.[Patient #], Sum(U.Current) AS Total1, Sum(U.[30-60]) AS Total2, Sum(U.[60-90]) AS Total3, Sum(U.[90+]) AS Total4
FROM [SELECT [Patient #], [Current], [30-60], [60-90], [90+] FROM...