The following query returns one column and one row with the Total. How do I display the EID column also?
SELECT Sum(Issue.Closed)+Sum(Issue.Created)+Sum(Kana.Completed) AS Total
FROM Issue INNER JOIN Kana ON (Issue.DateTime = Kana.DateCompleted) AND (Issue.EID = Kana.EID)
WHERE (((Issue.EID)="E173495")) HAVING (((Issue.DateTime)>=#3/20/2014# And (Issue.DateTime)<#4/4/2014#));