En Masse changes vs. individual updates

  • Thread starter Thread starter carlee
  • Start date Start date
C

carlee

Hi there,

I have a button that when clicked, executes 7 seperate
queries. THis is done to complete a record archiving
process.

Problem:

The queries work fantastic, but for one archive at a
time. I want to be able to click the button once and all
items to be archived will be.

How can i get this to work?

Regards,
Carlee
 
The queries work fantastic, but for one archive at a
time. I want to be able to click the button once and all
items to be archived will be.

How can i get this to work?
Click to expand...

By running a query that updates all the items. Without knowing what
code you now have nor anything about your table structures it's a bit
hard to say just how this would be done, but I'd guess that you would
have the code execute one or more queries, each of which would update
zero or more records based on some criteria.
 
Back
Top