Append & delete queries

[BrookieOU]

I have a tblEmployees and a tblCandidates. When we hire a candidate I would
like to append their basic info (name, address, ss#) to the employee database
and delete it from the candidates database. I would ultimately like to do
this in a form, but right now I am having trouble with the append and delete
queries. Basically my problem is I don't know how to do one. I've tried
reading here on the forum, but can't find a simple answer for what I'm
looking for...any help?

 

[BrookieOU]

I have a tblEmployees and a tblCandidates. When we hire a candidate I would
like to append their basic info (name, address, ss#) to the employee database
and delete it from the candidates database. I would ultimately like to do
this in a form, but right now I am having trouble with the append and delete
queries. Basically my problem is I don't know how to do one. I've tried
reading here on the forum, but can't find a simple answer for what I'm
looking for...any help?

I can't find any simple instructions on how to do an append or a delete
query. Sorry if this is too simple!