how to save calculated value to table field

[accesconfused]

Hi all,
I know saving calculated values to a table field are generally taboo. however, i want to assign each record that is entered a new ID based upon the person entering data (such that if i have multiple persons entering data at the same time the record ID's from each individual will not cancel eachother out.) I had thought a simple solution would be multipling the ID# of each data enterer by1000 and working from there (ie records 1, 2, 3, entered by data enterer#6 would be 6001, 6002, 6003). I have managed to make that work out as a calculated value on a form - but i am struggling with saving that value to a table.
any advice woudl eb appreciated, thanks so much

 

[plog]

You have not logically made a case for storing calculated values. In fact, it sounds like your issue has nothing to do with totals, but with storing data related to who was entering it.

Can you better demonstrate your issue with data?

 

[MarkK]

the record ID's from each individual will not cancel eachother out.

You've described this as the problem, but I don't know what that means. How do entries "cancel" each other?

You have many people entering data. Presumably they log on to your system and are identified or are identifiable. Maybe they have or need a UserID. Then, in each new record add a field called UserID, and when a particular user enters a record, put that user's UserID into that field.

Solved? Or do I not understand the problem?

 

[accesconfused]

thanks for getting back to me. the issue is related to storing data relative to who was entering it.

"You have many people entering data. Presumably they log on to your system and are identified or are identifiable. Maybe they have or need a UserID. Then, in each new record add a field called UserID, and when a particular user enters a record, put that user's UserID into that field." --MarkK

Users currently do not log on before adding entries to the database. I was not sure how to initiate a log-in process... so instead I have users select their name at the beginning of every record entry. Is the best way to deal with this dilemma to create a system in which users must log on? If so, may you point me in the direction of instructions that will show me how to do so? thank you

 

[MarkK]

so instead I have users select their name at the beginning of every record entry

Why not have them do this once per day rather than once per record? And then, when they do this, that is them logging on.