Database query

[Guest]

I have the following sql:
SELECT Sector, COUNT(Sector) as No
FROM Results
Group BY Sector

Where Sector is in my Results table. But i get a database results wizard
error: The SELECT statement includes a reserved word or an argument name
that is misspelled or missing, or the punctuation is incorrect.
Number: -2147217900 (0x80040E14)

It all looks ok to me but....... could do with some advice! Thanks.

 

[Jon Spivey]

Hi,
No is a reserved word. Try

SELECT Sector, COUNT(Sector) as NumSectors
FROM Results
Group BY Sector
or
SELECT Sector, COUNT(Sector) as [No]
FROM Results
Group BY Sector

 

[Guest]

Hi Jon,

That's nailed it! Thanks so much. Ray

Hi,
No is a reserved word. Try

SELECT Sector, COUNT(Sector) as NumSectors
FROM Results
Group BY Sector
or
SELECT Sector, COUNT(Sector) as [No]
FROM Results
Group BY Sector

--
Cheers,
Jon
Microsoft MVP

I have the following sql:
SELECT Sector, COUNT(Sector) as No
FROM Results
Group BY Sector

Where Sector is in my Results table. But i get a database results wizard
error: The SELECT statement includes a reserved word or an argument name
that is misspelled or missing, or the punctuation is incorrect.
Number: -2147217900 (0x80040E14)

It all looks ok to me but....... could do with some advice! Thanks.