C
Clay
Hello All:
Newbie question here....I really don't know the proper way to ask this
question or if it is even the correct way to try going about getting this
accomplished.
I have a table "Table1" with fields "counterID" and "projectnumber".
What I would like to do is for each project number I want the counterID
filed to increment.
Meaning if I insert 3333 into the projectnumber field then counterID field
would set to 1 then..
I do it again ..insert 3333 into the projectnumber field and the counterID
would increase to 2 then
this time I enter 4444 into the projectnumber field and the counterID filed
would set to 1 again...etc....etc...hopefully you get the idea...
right now I can increment the counterID field on the form using the
following code...
I just can't figure out how to count based on the value of the projectnumber
field.
Any help or direction would be greatly appreciated.
Thanks
Clay
Newbie question here....I really don't know the proper way to ask this
question or if it is even the correct way to try going about getting this
accomplished.
I have a table "Table1" with fields "counterID" and "projectnumber".
What I would like to do is for each project number I want the counterID
filed to increment.
Meaning if I insert 3333 into the projectnumber field then counterID field
would set to 1 then..
I do it again ..insert 3333 into the projectnumber field and the counterID
would increase to 2 then
this time I enter 4444 into the projectnumber field and the counterID filed
would set to 1 again...etc....etc...hopefully you get the idea...
right now I can increment the counterID field on the form using the
following code...
I just can't figure out how to count based on the value of the projectnumber
field.
Any help or direction would be greatly appreciated.
Thanks
Clay