LittleNick
Technical User
Hi All,
I have a table like this
ID Item RcdCount
02 x
02 y
02 z
05 a
05 b
04 j
And I want to update it to look like this
ID Item RcdCount
02 x 3 (Because there are 3 records of ID 02)
02 y 3
02 z 3
05 a 2
05 b 2
04 j 1
Thanks for your helps.
I have a table like this
ID Item RcdCount
02 x
02 y
02 z
05 a
05 b
04 j
And I want to update it to look like this
ID Item RcdCount
02 x 3 (Because there are 3 records of ID 02)
02 y 3
02 z 3
05 a 2
05 b 2
04 j 1
Thanks for your helps.