Thank you for your help.

I tried your suggestion and I receive a message that states ) records have
been updated due to record type conversion. Rank is numeric, Agegroup is
text. So I used your STRING example. What am I doing incorrectly.
--
Thank you for your help.


"vanderghast" wrote:

You are already in a kind of where clause, so add extra condition with AND:


UPDATE AAJGAJuniors SET aajgajuniors.rank =
dcount("1","aajgajuniors",
"score=" & [score] " AND agegroup =" & [agegroup] );


assuming agegroup is a number. If it is a string:


UPDATE AAJGAJuniors SET aajgajuniors.rank =
dcount("1","aajgajuniors",
"score=" & [score] " AND agegroup =""" & [agegroup] & """");





Vanderghast, Access MVP


"Bill" wrote in message
...
I have the following SQL statement that will rank my data. I am trying to
perform that ranking within age groups. I cannot get it to work. Can
anyone
help?

The statement below works but it ranks all the data 1 thru whatever.

UPDATE AAJGAJuniors SET aajgajuniors.rank =
dcount("1","aajgajuniors","score=" & [score]);


When I try to add the where clause as below, it will not rank by age
group.
What am I doing wrong?

UPDATE AAJGAJuniors SET aajgajuniors.rank =
dcount("1","aajgajuniors","score=" & [score]) where "agegroup =" &
[agegroup];

Thank you for your help.