Iterate through field and count records

[k_holt69]

Hi All

I need to iterate/count how many time a record is returned in a loaded table eg. I need this to then create a Key field. Tried a view options without any luck. Any suggestions?

User	Count
kh1	1
kh1	2
kh1	3
kh2	1
kh3	1
kh3	2
kh4	1

Thanks

[Kushal_Chawda · Accepted solution]

@k_holt69  try this

Load *, 
     AutoNumber(RecNo(),User) as Count
FROM Table;

[p_verkooijen]

@k_holt69 you mention a Key field, could you elaborate?

[k_holt69]

Thanks - Just what I need 🙂