Need to count number of students visiting each office.

[varu]

I need a query which counts the number of students visiting each office. Till now, I have a query which lists name of the students who have visited each office and how many times they have visited.

^This is what I have till now. But I need the count for each office. For example, 7 students have visited Career Planning but the total number of meetings for that office is 9 since two students visited twice. How do I get my query to count the number of students? (Career Planning =7)

[ranman256]

remove the [calculate NAME] from the query.

[varu]

I tried that.But that just gives me the total number of appointments. So using the same example, it would say Career Planning =9 and not 7.

[orange]

try
Select [AREA], Count([AREA])
FROM yourtablenameGoesHere
GROUP BY [AREA]

[varu]

@orange
This gives me the same problem! It counts number of meetings and not the number of individual students who have had meetings

[orange]

Please show us the design of each of your tables. And some sample data. And a clear statement of WHAT you are trying to do. You can use your test data to create a sample of what you want as result.

[orange]

double post............... removed latest