Hi all,
Im trying to follow the ranking Examples from:
http://support.microsoft.com/default.aspx?scid=kb;en-us;208946htm
whilst the northwind example works when i try it with my data i get the above error message despite having tried to do it the alias way or by writing a seperate query, its says the it doesn't recognise the name- the syntax is right as you can see:
GCSE Ranking: (SELECT COUNT (*) FROM Ranker WHERE [CountOfStudentId] > [Ranker1].[CountOfStudentId])+1
and for some reason it doesnt recognise the query ive set up, despite it existing in my query list- please help im going absolutly crazy!!!
greg
Im trying to follow the ranking Examples from:
http://support.microsoft.com/default.aspx?scid=kb;en-us;208946htm
whilst the northwind example works when i try it with my data i get the above error message despite having tried to do it the alias way or by writing a seperate query, its says the it doesn't recognise the name- the syntax is right as you can see:
GCSE Ranking: (SELECT COUNT (*) FROM Ranker WHERE [CountOfStudentId] > [Ranker1].[CountOfStudentId])+1
and for some reason it doesnt recognise the query ive set up, despite it existing in my query list- please help im going absolutly crazy!!!
greg