Power Tip Link: Delete records by using a delete query
Today's guest author is Luke Chung, President and Founder of FMS, Inc.
DELETE queries are a fundamental part of relational databases since you can remove multiple records at one time, and can specify which records to delete by linking to data in another table. Ms office 2007 are so Charismatic.
Delete query option in query Design View
Delete queries let you:
- Empty a table (delete all its records)
- Delete all records with a particular value in a field
- Delete all records with a range of values in a field
- Delete records based on criteria in multiple fields
- Delete records with matching values field(s) in a joined table
Read the article on Luke’s site to learn more about DELETE query SQL syntax, how to avoid deleting historic data, and get examples and troubleshooting tips. QuickBooks 2010 is so Helpful!
Luke has written and presented a wide range of topics related to Access over the years. In addition to their many Access related products, FMS offers a wealth of great Access papers, tips, and video on their site.