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

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.

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

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.

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.

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?