how do i convert an access date/time field value to integer?
I imported a text file from a lotus approach database into ms access. the date field is 1/27/1995 and i would like to convert it to an integer date field where it will read 12795. From there i will export the data to a sql table where it is defined as an integer. Please help.