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

deleted queries

ResolvedVersion 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:

Insert The Current Time

To insert the current time into a Table field or Form textbox use:

Ctrl+Colon(:)

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.