Cut Query?

L

lrxc

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

Marie

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
 
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
Click to expand...

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