Time calculations not sorting properly

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CraigJ - 27 Oct 2007 23:20 GMT

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

Reply to this Message

Douglas J. Steele - 27 Oct 2007 23:37 GMT

Try using the TimeValue function on the field.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hi,
>
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

CraigJ - 31 Oct 2007 21:29 GMT

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,
>
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

CraigJ - 31 Oct 2007 21:36 GMT

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
..

> Hi,
>
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Douglas J. Steele - 31 Oct 2007 21:58 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hi Doug,
>
[quoted text clipped - 13 lines]
>>
>> Thanks

Reply to this Message