Inner Join doesn't work, Help

E

elena

Hi, All

The following query return exception:
"... query does not include the specified expression Master.Viol & " " &
Violat.Description AS Violation as part of an aggregation function"
Please, what is wrong with query?

SELECT Master.Viol & " " & Violat.Description AS Violation,
COUNT(Master.TickNo) AS TotalTickets, Sum(Master.AmtVl) AS SumOfAmount
FROM Master INNER JOIN Violat ON Master.Viol=Violat.Viol
WHERE (((Master.IssDate) Between [Enter start Date] And [Enter end Date]))
GROUP BY Violation
ORDER BY Violation;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top