I have a query which lists all the hours in a day. The [ Time] field is an Integer type, as I only need to list hours and this helps with oth calculations I have to do etc.
I am displaying this is a form and have been using the Format property for the [ Time] textfield like this to give a 'time' representation:
<font color=blue>00":00"</font color=blue>
this gives a nice 01:00, 02:00 etc.
How could i get the following: 01:00 - 02:00, 02:00 - 03:00
I have tried things like setting the control source to
<font color=blue>Format([ Time],"00") & ":00 - " & Format([ Time]+1,"00") & ":00"</font color=blue>
and tried playing with the Format field but to no avail. I know I can sort this by having the [ Time] field do this on the query ( i think), but is there a way of doing this type of calculation/formatting in the form? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
(added a space in [ Time] to stop the big hourglasses [img]/forums/images/smilies/wink.gif[/img] )