counting number of visits query 1

[topwaya]

I am trying to have a query display the number of visits for a specific location. Does someone have an idea on where I'm going wrong?

SELECT [Fitness Center Location] AS WorkOutLocation, Count(*) AS [Distinct Visits]
FROM qryFCVisitsPID
GROUP BY [Fitness Center Location]
HAVING (("WOLoc"=[Fitness Center Location]));

The qryFCVisitsPID is:

SELECT DISTINCT tblLoc.LocName, tblFCUtil.PID, tblFCUtil.WOD, tblFCUtil.WOTme, tblFCUtil.WOLoc
FROM tblLoc INNER JOIN tblFCUtil ON tblLoc.LocID = tblFCUtil.WOLoc;

The qryFCVisitsPID shows me each visit by each person, I ultimately want to have have a form with a drop down box to filter the visits by WOLoc (workout location), LocName (work location), or person (PID).

Any help is appreciated - thank you!!

 

[PHV]

Something like this ?
SELECT WOLoc AS WorkOutLocation, Count(*) AS [Distinct Visits]
FROM qryFCVisitsPID
WHERE WOLoc="Fitness Center Location]"
GROUP WOLoc;


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[topwaya]

Thank you very much!!

The following worked like a charm!

SELECT WOLoc AS WorkOutLocation, Count(*) AS [Distinct Visits]
FROM qryFCVisitsPID
WHERE WOLoc="[Fitness Center Location]"
GROUP BY WOLoc;