What wrong with my query

[samia]

Hi Guys,

what could be the probelm with my query? Here:
******************
SELECT tblPartnerProfile.PartnerType AS [Org Type], tblPartnerProfile.PartnerName, tblPartnerProfile.PartnerLoc1, tblPartnerProfile.PartnerStatus AS Status, Count(PartnerType) AS TotalType,
FROM tblPartnerProfile
WHERE PartnerLoc1 = 1 OR PartnerLoc1 = 2
******************************
I would like to have it give a count of how many [Org Type] 1 and 2 for Loc1 1 and Loc2 2.

Thanks in advance,

Samia

 

[Alc]

I think this comma might cause an error message.

TotalType,

 

[samia]

I think this comma might cause an error message.

TotalType,

Thanks Alc, but ihas still failed.

 

[Alc]

What is the erro message?

Also, apologies but I missed the part about the grouping and concentrated totally on the syntax. The following may work:

SELECT 
tblPartnerProfile.PartnerType AS [Org Type],                   
tblPartnerProfile.PartnerName, 
tblPartnerProfile.PartnerLoc1, 
tblPartnerProfile.PartnerStatus AS Status, 
Count(PartnerType) AS TotalType,
FROM 
tblPartnerProfile
WHERE 
(PartnerLoc1 = 1) OR (PartnerLoc1 = 2)
GROUP BY 
tblPartnerProfile.PartnerType,
tblPartnerProfile.PartnerName, 
tblPartnerProfile.PartnerLoc1, 
tblPartnerProfile.PartnerStatus;

 

[samia]

Alc,

The error is 'the SELECT statment includes a reserved word or an argument name that is mispelled or missing, or the punctuation is incorrect.'

Thanks,

Samia