after updating or entering a comment, the date is entered into that comment

message from =?Utf-8?B?UnV0aA==?= on 3 Jun 2004
Date Stamp: after updating or entering a comment, the date date is entered into that comment (modification date)
Help please!
Ruth
 
John Vinson replied to =?Utf-8?B?UnV0aA==?= on 03 Jun 2004
Where and how are you storing the comment? Multiple comments in a
single Memo field, multiple records in a table (better), or what?
Would it perhaps not be better to follow the relational design
principle that each field should be "atomic" - have only one value -
by using a table with a text field for the comment, and a separate
date field defaulting to Date()?

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
 

Archived message: after updating or entering a comment, the date is entered into that comment (Microsoft Access Database)