A loop and INSERT INTO

  • Thread starter Thread starter Peter Castlehouse
  • Start date Start date
P

Peter Castlehouse

This is a follow-on to Mike Painter's help on my prescription takeaways
problem.
Originally called [Takeaways Dilemma]

Mike suggested the following:

<snip>
It should be just a matter of duplicating the records with different values
for date(?) and refills or whatever you use to track the takeaways.
This can be done with a loop and INSERT INTO
</snip>

however I don't know how to do a loop and INSERT INTO
can someone point me to some where that might help, or even better, advise
me?

tia, and thks Mike P...

OzPete
 
-----Original Message-----
This is a follow-on to Mike Painter's help on my prescription takeaways
problem.
Originally called [Takeaways Dilemma]

Mike suggested the following:

<snip>
It should be just a matter of duplicating the records with different values
for date(?) and refills or whatever you use to track the takeaways.
This can be done with a loop and INSERT INTO
</snip>

however I don't know how to do a loop and INSERT INTO
can someone point me to some where that might help, or even better, advise
me?

tia, and thks Mike P...

OzPete



.
INSERT INTO is a SQL command, create some APPEND queries,
Click to expand...
then look at them in the SQL view. A loop is simple, for
example, the following will loop a line of code 3 times


c=1

do until c>3
CODE GOES HERE

c=c+1

Loop

If i can be any more help, then mail me @
(e-mail address removed)
 
Back
Top