Hello All

How do I get a number field in ACCESS to increment by one each time an update is made to that record. What I'm trying to achieve is an idea of how many updates have been made to a particular record.

Thanks

Stefan

I'd set it up in the web page itself and just record the number in a db field. I'd take the onMouseDown or maybe the form action would call a javascript before submitting and increment the variable before you send the form.

Rick Harding
U of M CS Student / Network Admin for MSU FAME
"Techies just think differently...at least that's what they keep telling me"

Retrieve current number of updates from DB and use Command/Stored Procedure to update that record. New value would be NoOfUpdates = NoOfUpdates + 1

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hello All

How do I get a number field in ACCESS to increment by one each time an update is made to that record. What I'm trying to achieve is an idea of how many updates have been made to a particular record.

Thanks

Stefan




<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager