Microsoft Access-根据字段值更改创建数字序列?

对于这样的查询数据:

   +-------+---------+ 
   | Name  | Details | 
   | JEFF  |  TEST1  |
   | JEFF  |  TEST2  |
   | JEFF  |  TEST3  |
   | BOB   |  TEST1  |
   | BOB   |  TEST2  |
   +-------+---------+

如何查询,以便添加一个数字序列(1、2、3…)以便每次名称更改(即从Jeff更改为Bob)时重置回1?

是否可以使用dcount函数?

到目前为止我所拥有的是(它的顺序不正确):

Number: (SELECT COUNT(*) FROM  [dQuery] 
WHERE  [dQuery].[Name] =  [dQuery].[Name] 
AND  [dQuery].[sequence] >=  [dQuery].[sequence])

更新1:

正确的查询是:

SELECT [dQuery].Name, [dQuery].[sequence], (select count([dQuery].Name) + 1 
from [dQuery] as dupe where 
dupe.[sequence]< [dQuery].[sequence] and dupe.name  = [dQuery].name
) AS [Corrected Sequence]
FROM [dQuery]
WHERE ((([dQuery].Name)="jeff"))
ORDER BY [dQuery].Name, [dQuery].[sequence];