Rank

[Judge]

I found the article that some of the previous Rank question and answer posts refer to but I am still having problems creating a rank. I've got a list of territories and the growth percent for each territory. I want to assign a rank in descending order to later assign points for a sales contest we are running. I'm using a table I've previously created with the fields Terr and Growth. I changed the Terr field list alias property to Terr1. I tried copying the expression from the article using my fields as:

Rank: (Select Count (*) from Terr Where [Growth] <_ [Terr1].[Growth]+1

I keep getting a syntax error when I try to run the query. Can anyone help?!?

 

[Norie]

Rank: (Select Count (*) from Terr Where [Growth] <_ [Terr1].[Growth]+1

Is the underscore actually what is in the expresssion, or has it copied over wrong.

It definetely shouldn't be there.

 

[Judge]

The underscore was there, but I've taken it out and it still give me an error.
Also, that is not supposed to be a smiley face at the end of the expression, it is supposed to say '+1 (semicolon) )

That is how I copied it from the article. Any ideas?