How to Create a Delete Query to Delete Records from Tables in Microsoft Access

In this Microsoft Access tutorial, I'm going to teach you how to use a Delete Query to delete records from tables. We'll do a simple delete based on one table first, then we'll do a more complex delete query involving criteria from two tables.
LEARN MORE:
599cd.com/Delete
PRE-REQUISITE:
Query Criteria: 599cd.com/Criteria
RECOMMENDED COURSES:
Access Expert 15: 599cd.com/ACX15
Access Expert 16: 599cd.com/ACX16
LINKS:
Access Backup: 599cd.com/Backup
Don't Delete Data: 599cd.com/DontDelete
ISO Date Format: 599cd.com/ISO
Relationships: 599cd.com/Relationships
BECOME A MEMBER:
CZcams: / @599cd
or My Site: 599cd.com/THMember
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, delete query, Create and run a delete query, How to Create a Delete Query, How to Delete Data using a Delete Query, Delete Queries, delete query using two tables
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@wesleypchow]

Exactly what I needed - Thank you Richard!

[@dolittlediehard1670]

My teacher did a simple delete query but deleting records from one table based on criteria in another is also required. In our example, customers who attended the last auction but didn't buy anything are to be deleted. The criteria is salespersonID is null in the items table. So many thanks for the video.

[@dolittlediehard1670]

Except 😢 your example didn't work for me. I can't type False in the criteria cell for the customers table because there's no checkbox to say whether they're active or not. The items table contains the salespersonID and the CustomerID. If someone didn't buy something then in the items table the salespersonID is null. I can list the customers who didn't buy anything but i can't delete them. My delete query is not based on time.

[@599CD]

Sorry but I really don't understand your question. I need to see some screenshots. 599cd.com/Ask

[@benmoore8547]

brilliant video, super helpful loved it!!

[@599CD]

Thanks

[@codykniffen]

"Oh that's Geddy Lee" made my day.

[@599CD]

Love me some Rush

[@hershqadir7607]

thank you

[@599CD]

Welcome

[@brightonsendoi4745]

How do I eddit Data not entered in previous months

[@akee1618]

Where can i learn to bring a pop up window displaying remaining stock i have while entering a sales invoice?

[@599CD]

599cd.com/DLookup

[@apekshaverma9428]

Hii ..what is meaning of access (only pc )?
If i take 1 month trail of microsoft 365 apps fir business on my laptop ? Will access work on it ?

[@599CD]

Buy Access: 599cd.com/BuyAccess

[@gregoryjeffries8475]

I use a status indicator set to delete after performing whatever action needed for the data. Only records marked for delete are removed.

[@599CD]

Good idea

[@willmiranda9710]

How can I delete a single row of data containing over a 100 row of data. do not want to delete the remaining 99 rows of data.

[@ausproto]

Hi Rick,
How can I best automate a Delete Query?
I use an Audit Log, in which I would like it to automatically run a Delete Query every 2 months, deleting any record on the Audit Trail that is older than 60 days prior to the time of deletion (=Now() ). How can I best go about this?
Many thanks.