MS Access select and delete

**daiondoroga** · 08-15-2006, 08:45 AM

Hi
I am a new member and very new to database. I am having problem with MS Access data base. Example my text is "xyz" in a text field, txtField. Is there any way to run a query to delete x and z so I am left with y only. Can anyone help please...

Regards

**chrishirst** · 08-15-2006, 06:48 PM

not in a single query,

you would need to read the data, process it in some code or other, then update the database record with the new data.

**ADAM Web Design** · 08-15-2006, 10:23 PM

In a single text field, it would be possible. The problem is before the query, you'd have to do some sort of manipulation.

Code:

Dim Delete_1, Delete_2
Delete_1 = Mid (your form field, 1, 1)
Delete_2 = Mid (your form field, 3, 1)
SQL_Query = "Delete from (table) where (field) In ('" & Delete_1 & "', '" & Delete_2 & "')
Conn.Execute (SQL_Query)

That's rough code. Very rough code. Play with it and make it better, but it's the rough idea.

**chrishirst** · 08-16-2006, 04:11 AM

Adam, your query would delete records where the field contained the values of Delete_1 or Delete_2 would it not.

It seemed to me that the OP wants to do string manipulation within the SQL Server (Access) context. Which would need stored procedures to accomplish in a single query.

**ADAM Web Design** · 08-16-2006, 11:55 AM

That's exactly what it would do. It would delete those two values, which would have to be extracted from the text field.

As far as SPs used to accomplish this in a query...I'm not that good with them so I really wouldn't know. The easiest way I could personally see to do it is ASP string manipulation.

Mind you, a little more clarification is probably in order at this point. diaondoroga, what exactly did you want to accomplish?