time conv.

[george]

ok, I am not a huge access user or a programmer by any
means, I am just trying to use access in its simplest
form. I am entering data into an excel file and then I
opened the file as a table in access and created my
queries and forms from there. the only real problem I am
running into right now is the fact that when I go into
access my times are showing up like this

12/30/1899 7:55:00 AM

and at one point I got rid of the 1899, not sure how, but
I did... and now its back. I read something on the
message board about zeros making the 1899 appear but I
wasn't too sure what they meant.

thanks

 

[george]

i understand the short date if i am in the pivot table and
can change it if theres the properties box option, but it
always resets itself every time i close and re-open
access, also... this problem is in the table, maybe i am
missing something, thanks though

 

[Larry Daugherty]

Look up Format in Help.

 

[george]

thanks, i got it.

-----Original Message-----
Look up Format in Help.

--
-Larry-
--




.