Hello all. I have known my way for many years in Access but I am novice in VBA, so I require you generous help and expertise. I guess it should be pretty simple.
I have this query:
proyect_id organization_id previous_counter 272 57 0 272 15 0 274 28 0 296 35 1
and I want to create a VBA module that can create a new field (new_counter) based on the old counter and the count of organizations per project, like this:
proyect_id organization_id previous_counter new_counter 272 57 0 1 272 15 0 2 274 28 0 1 296 35 1 2
Is that possible? Any help would be greatly appreciated.
Thank you very much.