Christy wrote:
> I exported data from a commercial database and am
> modifying it in Access for a client. There is a field
> called import ID that I use to link tables and will be
> needed to re-import the data to the commercial db when
> I'm done. It is a text field. I created a time/date
> field called AutoGen. I set it to the value of now with
> a mask of mmddyyyyhhnnss, which I figure is pretty
> specific and unique. It gets created when a new record
> is created. I then ran an update query to set the import
> ID to the AutoGen value when Import ID was null. The
> only problem is, the value of the import id is now
> 09/10/03 5:25:34 PM not 09102003062534 like I want it to
> be. How can I paste the information in the current
> format to the Import ID field?
>
> Or - is there a better solution to my mousetrap? I'm
> running out of ideas!
>
> Thank you!!
However you apply the Format to it, the underlying value in a Date/Time
Field is floating point, where the whole number part is the number of
days since 30 December 1899 and the decimal part is the time fraction
(12 noon is 0.5). This will give a unique value in your instance but
you could also use Autonumber to deliver a unique value for each record
created.
Is there a reason why you would need to display the unique record
identifier? To do so would be unusual.
hth
Hugh
|
Similar Threads
