G
Guest
In my line of work I use hours seperate from the date field in several
queries, so I have separate date & hour fields in my tables. One query I'm
writing requires the output to have the hours displayed as two digit (of
course hours 1-9 are only one digit!) And I have the field formatted as
numeric. How do I add a preceeding '0' to only hours 1-9 and leave the rest
of the 24 alone?
Thank you!
Cathy
queries, so I have separate date & hour fields in my tables. One query I'm
writing requires the output to have the hours displayed as two digit (of
course hours 1-9 are only one digit!) And I have the field formatted as
numeric. How do I add a preceeding '0' to only hours 1-9 and leave the rest
of the 24 alone?
Thank you!
Cathy