I need to create an append query.
I have a "leads" table that outside agents populate with a potential sales lead. Once my agent accepts the lead he changes the status of that lead. I need a query, triggered by the status change to append the lead to my "clients" table.
Of course I'll also need a delete query to delete the record from the "leads" table.
In addition I'll need to be able to create some update queries too for other tasks in my database.
I can't find any help on this at all. Gee I miss SQL