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

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.
culwatrncaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
You can use this:

Like "T" & "*"

mx
0
 
LimbeckCommented:
hi, always make a backup before using a delete qry:

DELETE yourtable.*
FROM yourtable
WHERE Left([yourfield],1)="T";
0
 
culwatrncaAuthor Commented:
awsome... thank you and thank you for the quick reply...
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You are welcome.  Note that Limbeck's solution is an equivalent way of doing the same thing.

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.