Looping values in database

[Imran Ghani]

Hi! I want to make a loop that would be able to take values from three fields
say no. of values to be made, start time and an increment time say 15
minutes. I want to add these updated fields in the database table whereby it
would be possible to look at different appointment times with a fixed
difference of time and repeated for the number of appointments for the
specific date for say a doctor. Client names and doctor name is also to be
inserted in the database table. Any helpful advise in this regards will be
highly appreciated. Thanks in advance.

 

[Piet Linden]

Hi! I want to make a loop that would be able to take values from three fields
say no. of values to be made, start time and an increment time say 15
minutes.  I want to add these updated fields in the database table whereby it
would be possible to look at different appointment times with a fixed
difference of time and repeated for the number of appointments for the
specific date for say a doctor. Client names and doctor name is also to be
inserted in the database table. Any helpful advise in this regards will be
highly appreciated. Thanks in advance.

you need a for loop and then inside it, increment your date value.
Then insert the record into a table. Lotsa fun

look up Loop in VBA help and probably recordset so you can do the
insert.

 

[Imran Ghani]

Thanks for your helpful advise. I'd be much greatful if you could just
illustrate it by a fine example.