Looping values in database

  • Thread starter Thread starter Imran Ghani
  • Start date Start date
I

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.
 
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.
Click to expand...

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.
 
Thanks for your helpful advise. I'd be much greatful if you could just
illustrate it by a fine example.
 
Back
Top