Timestamp for when a specific field is filled

[ComradeGrumbles]

I searched around the forums but couldn't quite find this question.

I have a ticket database where tickets are added to access with no priority scores on them. Over time, meetings and discussions, those tickets are given scores through a form on my database.

What I would like to do is somehow add a timestamp that shows exactly when a ticket went from being unscored, to having a priority score assigned to it. Note, before the ticket is scored; the Priority Score field is still blank. Null?

An idea I had was to somehow put a timestamp on the "Priority Score" field in my form that will only timestamp when that field goes from being blank to when it gets a number for the first time. It will not change the timestamp when that number is changed down the road. (We edit the priority scores, but I only want to know when the ticket was actually scored for the first time. This is for reporting purposes, how many new tickets we score each month, etc)

Could I do something along the lines of assigning code to the BeforeUpdate value of my Priority field on the form? Although I'm assuming this would put up a timestamp any time the field is altered afterwords also. I'm still getting the hang of this. What do you suggest?

Thanks!

 

[bob fitz]

I would suggest adding a date type field to the table. In the Before or After Update event of the Priority field put some code to determine if the new date field is null or not and add the date and time to that field if it is null using Now().

 

[ComradeGrumbles]

Thank you! This works