As easy as it sounds I don't seem to be able to get this right.
Looking for a query that will take a value say 4.5 and convert to datevalue in hours so will end up as 04:30:00
Any help appreciated.
Thanks
:banghead:
Looking for a query that will take a value say 4.5 and convert to datevalue in hours so will end up as 04:30:00
Any help appreciated.
Thanks
:banghead: