In access, how do you delete records in a table the begin with a .

[Guest]

If you can help me. I am in a Intro to computers class and i am stuck. The
task in using a query, delete all records in the Item table where the
description starts with the letter S. anyone who can give me a clue .. please
help. the assignment is due tomorrow and i am lost. thank you!

 

[Joseph Meehan]

If you can help me. I am in a Intro to computers class and i am stuck. The
task in using a query, delete all records in the Item table where the
description starts with the letter S. anyone who can give me a clue ..
please help. the assignment is due tomorrow and i am lost. thank you!

Maybe this is cheating

create a query based on the table. You only need the one field you are
searching on, but the others will not hurt.

In design mode, on the "Criteria" line type in "S*"

Go back to display mode and make sure you have the records you want to
delete.

Go back to design mode and select "Delete Query" from the menu and then
click the "!" to run the delete query.

Now write back and tell us how it went and if you understand why it
went.

The magic help words would have been "delete query" and "select query"
or "filter"

 

[Guest]

Thank you so much. I am also in Intro to Computers, must be the same course,
except I was to delete all records contains "R." Your post helped me
tremendously. I couldn't nuzzle out the way to do it and it was making me
batty! And I don't think it was cheating: the textbook actually said "hint:
go online for help with this one" (I'm paraphrasing here).

Blessings,
Julia

 

[Joseph Meehan]

Thank you so much. I am also in Intro to Computers, must be the same
course, except I was to delete all records contains "R." Your post helped
me tremendously. I couldn't nuzzle out the way to do it and it was making
me batty! And I don't think it was cheating: the textbook actually said
"hint: go online for help with this one" (I'm paraphrasing here).

Blessings,
Julia

I am glad it helped.

I have worked as a professional for some time, although I would not
count myself as an expert in Access, and I have a lot of questions that I
have brought here and learned by doing just that.