Cut Query?


G

Guest

Is their a way I could create a "cut query". What I mean by that is to cut
data from one table and place it in another. Sort of like an update or append
query, but I need the data from the original location removed.

If that is possible can that query be but on a form in a button?
 
F

fredg

Is their a way I could create a "cut query". What I mean by that is to cut
data from one table and place it in another. Sort of like an update or append
query, but I need the data from the original location removed.

If that is possible can that query be but on a form in a button?
You can do it from one button, but you'll need 2 different queries.
Make sure any criteria involved is exactly the same for the Append and
Delete queries.

DoCmd.OpenQuery "AppendQueryName"
DoEvents
DoCmd.OpenQuery "DeleteQueryName"
 
Ad

Advertisements

G

Guest

I'm trying to do the same thing, but still have questions.
In doing this, how can I specify the criteria in the macro for the records I
want appended and then deleted?
-Marie
 
Ad

Advertisements

F

fredg

I'm trying to do the same thing, but still have questions.
In doing this, how can I specify the criteria in the macro for the records I
want appended and then deleted?
-Marie
You specify the query criteria in the query itself, not in a macro.
Open the query in design view.
If you look at the query grid, you will see there is one row marked
"Criteria".

Read Access help.

If you need more specific help you'll need to be more specific (and I
would suggest you start a new thread).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top