R ruthlg Guest Jun 2, 2005 #1 This is going to be a dumb question for all you Access experts, but how do I insert a field that will automatically display the date that the record was created (not updated, but created)? Thanks!
This is going to be a dumb question for all you Access experts, but how do I insert a field that will automatically display the date that the record was created (not updated, but created)? Thanks!
T trucktime Registered User. Local time Today, 14:10 Joined Oct 24, 2004 Messages 556 Jun 2, 2005 #2 Date Use a Date/Time Field and set the default value to: =Date()
ghudson Registered User. Local time Today, 16:10 Joined Jun 8, 2002 Messages 6,193 Jun 2, 2005 #3 trucktime said: Use a Date/Time Field and set the default value to: =Date() Click to expand... Just to clarify... In the design view of the table, not the form. ;-)
trucktime said: Use a Date/Time Field and set the default value to: =Date() Click to expand... Just to clarify... In the design view of the table, not the form. ;-)
G godofhell Database Guru Local time Today, 13:10 Joined May 20, 2005 Messages 180 Jun 3, 2005 #4 If you want to see the date and time then simply use =Now() and store it on a field called RecordCreated or something similar.
If you want to see the date and time then simply use =Now() and store it on a field called RecordCreated or something similar.
