I have a table that has a field that is defined as x-xxx, and I'm going to expand that field to be xx-xxx. What I would like to do is build an update query to place a P in the first position of each field i.e. Px-xxx. Is there anyway to reference the first position of a field with Access query? Thanks Travis.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Update Query - Parital Field
- Thread starter blackte
- Start date
tlbroadbent
MIS
The following will do what you want.
Update Table Set ColName="P" & ColName Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Status
Similar threads
- Locked
- Question
- Locked
- Question