queries and mulitple row headings (1 Viewer)

[manwen]

I'm kind of new at this, but I'm eager to learn so please bear with what is probably a really easy question.

I have a two crosstab queries in which I pulled from total counts of a value based on two different row headings. For example, I have one query that gives the total count of doctors within a location and then I have one that gives total count of doctors within a specialty.
Now I'm trying to get total doctors within a specialty in a location. I tried making a simple query that pulled this data together from the previous two queries, but that doesn't work. Any help seeing the light would be appreciated. Thanks!!

 

[Jon K]

If your table contains the fields Doctor, Location, Specialty, you can count the number of doctors with a total query (type in the SQL View of a new query using the correct table name and field names):-

SELECT [Location], [Specialty], Count(*) as NumberOfDoctors
FROM [yourTable]
GROUP BY [Location], [Specialty]


(The square brackets are needed only if the table name or field names contain spaces.)