Adding minutes to time 1

[TudorSmith]

Hi,

My report has three rows

Interview one, Start Time
Meeting two, Start time
Meeting three, Start time

I want to dictate the start time of the first interview, but then have the 2nd & 3rd bound ot the value of the first so....

I1 = [StartTime]
I2 = [StartTime] + 10
I3 = [StartTime] + 20

I tried : Hour([StartTime]) & ":" & Minute([StartTime]) + 10
but all I get is #Error

Any clues...or better still, got a routine that I can place int he Control Source for the field?

birklea


birklea ~©¿©~ <><
I know what I know...don't presume that I know what I don't! Smithism!!!

 

[CosmoKramer]

Try this:

I1  [StartTime]
I2  =DateAdd("n",10,[StartTime])
I3  =DateAdd("n",20,[StartTime])

Hope this helps....

 

[TudorSmith]

Thanks CosmoKramer...worked a treat! birklea ~©¿©~ <><
I know what I know...don't presume that I know what I don't! Smithism!!!