Time calculations not sorting properly

  • Thread starter Thread starter CraigJ
  • Start date Start date
C

CraigJ

Hi,

a)I have data in an access database which was imported but the some of the
times are stored as 1/1/1900 10:35:00 instead of just 10:35, this wreaks
havoc when i try to sort them, I did see a CDec() function in access help,
but is not available? I did try a CDbl() just to see and it change the
other valid times to .786etc and the 1/1/1900 10:35:00 to 2.455etc, not sure
what to do here?


Thanks
 
Thanks Doug, very much! sorry it took so long, You see its a long story but
basically i dont have my pc at home.

It worked very well thank you!
 
Hi Doug,

I have this major access query for you it involves working with time and
procedures, I have used totals in a query, with the minimal set of fields as
adding more messes up the calculations i.e minimum time per session per day
...
 
Did you try the TimeValue function as I suggested? If so, did it work? If
not, what happened (and what did you expect to happen)?

You really aren't giving any information! Since this is a newsgroup about
queries, it would probably be a good idea to post the SQL for your query, as
well as some basic information about the underlying tables and the fields in
them.
 
Back
Top