HOW DO I DELETE A RECORD FROM TABLE AND IN THE SAME TIME PUT HIM .

's Computer Specifications

's Computer Specifications

I assume you mean you want to move a record from one table to another in the
same query. You can't.

You'll have to execute two queries; one to copy the record, and another to
delete the old one.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Kais Sheet" <Kais (E-Mail Removed)> wrote in message
news:012A1A87-FD69-4655-99EC-(E-Mail Removed)...
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Add / Delete record from table - How to reposition selected record in datagridview???	Cor Ligthert[MVP]	Microsoft VB .NET	0	31st Mar 2008 05:26 AM
Delete record if a matching record is present in another table	Kiwi_731	Microsoft Access Queries	3	20th Dec 2007 05:45 PM
I need to delete oldest record so that table only contains latest record	d.barson@btinternet.com	Microsoft Access Queries	2	17th Sep 2007 09:55 PM
How to delete a SQL Server record (descending from another record of the same table) with a C# application	polocar	Microsoft C# .NET	6	23rd Jul 2006 03:20 AM
Upon delete record, conditional delete record from another table	=?Utf-8?B?UmljaDEyMzQ=?=	Microsoft Access	6	14th Oct 2005 02:48 PM