Deleted queries

The UK's most regular instructor-led training courses.
Training information: microsoft access courses · Microsoft access courses · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Medium Priority · Version 2007

Deleted queries

David has attended:
Excel Intermediate course
Excel Advanced course
Access Intermediate course
Access Advanced course

by - delegate David [5 posts] (2008 Jun 24 Tue, 16:12) Reply

I want to save the deleted queries in order to have a record of the detailed queries

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 21 Fri	Bloomsbury	5	book now	£219	£235
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
Full Schedule: See all 48 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Deleted queries

by - trainer Stephen gold contributer [369 posts] (2008 Jun 25 Wed, 11:45) Reply

Hi David

Thank you for your question

Your best bet would be to first run the query as a make table or append query and write the data to be deleted to a seperate table in which you can store archive data

You could then run the delete query

Hope this is useful

Regards

Stephen

RE: Deleted queries

by - delegate David [5 posts] (2008 Jun 25 Wed, 12:31) Reply

Thanks Stephen, I'll try this. David

· Microsoft Access Courses
· Why go on a Microsoft Access Training Course?
· When Is Microsoft Access Not The Best Choice For Your Business?
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
· Microsoft Access Training Opens Doors

Please browse our web site to find out more about
microsoft access courses and other Microsoft training courses.