ms access中的on方法是一个相关子查询：

select t.*,
       (select count(*) from t as t2 where t2.fpid = t.fpid and t2.id <= t.id) as counter
from t;