Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Delete Query to Delete all records where the name starts with T

Posted on 2007-11-29
4
Medium Priority
?
419 Views
Last Modified: 2010-04-21
I am trying to create a Delete Query to delete all records where the name starts with T. I am not sure what to put in the criteria so that all records say in the name field are delete if the first letter is a T. I know this is simple but im not getting it.
0
Comment
Question by:culwatrnca
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 80 total points
ID: 20380300
You can use this:

Like "T" & "*"

mx
0
 
LVL 19

Expert Comment

by:Limbeck
ID: 20380301
hi, always make a backup before using a delete qry:

DELETE yourtable.*
FROM yourtable
WHERE Left([yourfield],1)="T";
0
 

Author Closing Comment

by:culwatrnca
ID: 31411868
awsome... thank you and thank you for the quick reply...
0
 
LVL 75
ID: 20380339
You are welcome.  Note that Limbeck's solution is an equivalent way of doing the same thing.

mx
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question