query for two values
am 15.02.2006 18:07:18 von C WhiteI have a query that will count everything by location:
SELECT DISTINCTROW [Tracking].[Location], Count([Tracking].[ID]) AS
Total
it will show me
location total
a 10
b 15
c 7
but I would like to break it down further, the records also store a
person's name (the field is called name), so that I can get it to show
me
location name total
a tom 3
a dick 4
a harry 3
b tom 5
b dick 6
b harry 4
c tom 1
c dick 2
c harry 4
i've been looking at this for a couple of hours now, and i can't seem
to find the answer anywhere, anytime i try to write something it gives
me the following error
"you tried to execute a query that does not include the specified
expression"
which obviously means i have no idea what i am doing
how do i write the query to display the breakdown by location and name?
thanks