Cut Query?

[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?

 

[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"

 

[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

 

[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).