Macros?

  • Thread starter Thread starter KSchnebly
  • Start date Start date
K

KSchnebly

I have a need to have access do some special manipulations.

I need it to take data from a table, modify it, then copy it back into the
table as new data. Can this be done, and How?
 
I have a need to have access do some special manipulations.

I need it to take data from a table, modify it, then copy it back into the
table as new data. Can this be done, and How?
Click to expand...

Yes, many ways - Macros would be my last choice, though. If by "new data" you
mean to create a new record leaving the original record alone, you could use
an Append query; if you mean to change the record in place, an Update query
would do the job.

For more detailed help please ask a more detailed question.
 
You could do an action query - specifically a make table query to copy your amended table to a new table

-------------------------------------------------------
For your FREE Access beginners ebook

http://www.access-databases.com/ebook

-------------------------------------------------------
 
Back
Top