Update Query????

wardy

Registered User.
Local time
Today, 16:01
Joined
Sep 4, 2007
Messages
21
hello all,
once again, any help anyone could give would be very very much appreciated,,,
i have a table that contains several fields of data,, my only problem (at this point) is one of my fields is called PL_Item,, the data in this field comes in this format:
PA-1111-2222-A

before i can do anything with this data i really need to dump the PA from the beginning of it,, is there an easy way to do this in Access? if so what would i need to enter in the criteria section of my query?
up until now i have been doing this is Exel before i import,, its a pain, i just wondered if this can be done by an update query?
thank you all very much for your kind help
regards
 
You can use the Mid() function to grab the data starting from any given character.
 

Users who are viewing this thread

Back
Top Bottom