how to edit all fields

[durilai]

I have a table that has a unique field. An example of the data is "12547-aname" and I need to make them all "12547". I am not sure how to do this, any help would be appreciated.

 

[PHV]

Something like this ?
UPDATE yourTable SET yourField = Val([yourField]);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[durilai]

How can you perform that in MS Access 2003?

 

[lespaul]

open a new query, switch to the SQL view, paste PHV's query, replace yourTable with the tablename you want to update, replace yourField with the name of the field you want to update and run the query.


Leslie

 

[durilai]

Well, not sure if you k now what I need. I dont want to change the field completely, I just want to edit the remaining fields. I used the SQL, but received the exact same output.

 

[lespaul]

An example of the data is "12547-aname" and I need to make them all "12547".

I dont want to change the field completely

if you don't want to change it completely, what exactly do you want to do?

Maybe if you provide a small data sample and your table structure and what you want it to look like when you're done, we will have a better idea of what you are really trying to do.

Leslie

 

[PHV]

So, what do you want to do exactly ?
Feel free to post some input samples and expected result.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[durilai]

That is exactly what the data is:

ID
12345-ABCDE

and I want to delete everything after the last number, so I want to remove the hyphen and the letters. Every record in the field is like that. Thanks for all of your help

 

[PHV]

And this action query doesn't do the trick ?
UPDATE yourTable SET ID = Val([ID]);

You may also try this:
UPDATE yourTable SET ID = Left([ID], InStr([ID], "-")-1)
WHERE ID Like "*-*";

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[durilai]

I was using a regular query, how do you make an action query.

 

[PHV]

By clicking the ! button.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244