deleted queries

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Deleted queries

Deleted queries

resolvedResolved · Medium Priority · Version 2007

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

Deleted queries

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

RE: Deleted queries

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

Thanks Stephen, I'll try this. David


 

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips


Server loaded in 0.09 secs.