?
Solved

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

Posted on 2007-11-29
4
Medium Priority
?
423 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
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. …

601 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