Hi All,
Not sure if this is possible but here goes.
I have a form with a time in the format "hh:nn". What I would like to do is create a query that takes the value from my form and adds a row for each 15 minute increment until it reaches a certain time i.e. 16:30.
So if the time on my form is 14:00 the query would display:-
14:15
14:30
14:45
and so on.
Thanks for any help on this.
Taff.
Not sure if this is possible but here goes.
I have a form with a time in the format "hh:nn". What I would like to do is create a query that takes the value from my form and adds a row for each 15 minute increment until it reaches a certain time i.e. 16:30.
So if the time on my form is 14:00 the query would display:-
14:15
14:30
14:45
and so on.
Thanks for any help on this.
Taff.