I am sure the answer to this is easy but I cant seem to get it. I need to sum a few columns. I have attached pictures of the query I want to sum and here is the SQL code if it is needed.
SELECT Area.Area, qryDICount.CountOfDI, qryDIInspectionStatus.[Descent Inspection], qryDIInspectionStatus.[Surface Inspection], qryCT_DITypes.[Type A], qryCT_DITypes.[Type A Modified], qryCT_DITypes.[Type B], qryCT_DITypes.[Type A or B Special], qryCT_DITypes.[Type C], qryCT_DITypes.[Type D], qryCT_DITypes.[Type E], qryCT_DITypes.[NDOT Type 2]
FROM ((Area LEFT JOIN qryDICount ON Area.Area = qryDICount.Area) LEFT JOIN qryDIInspectionStatus ON Area.Area = qryDIInspectionStatus.Area) LEFT JOIN qryCT_DITypes ON Area.Area = qryCT_DITypes.Area
WHERE (((Area.Area)<>"ALL"))
ORDER BY Area.ID;
I have tried using a total query but I dont have anything for it to group by. I tried putting in a variable like Total:"" but that didnt work. All of my other queries have had tables which I could LEFT JOIN to create my row names but now I just want the totals. Thanks for help.