Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Concatenation Access

Posted on 2014-02-12
2
Medium Priority
?
209 Views
Last Modified: 2014-03-05
Hi,

Im looking to update a field in an access table using concatenate.

My field currently contains "123" i want it to contain "123USABC"

How do i concatenate and replace?

Thanks
0
Comment
Question by:Seamus2626
2 Comments
 
LVL 96

Accepted Solution

by:
Lee W, MVP earned 1000 total points
ID: 39853597
If the field is numeric then you'll have to change it to a character based field.
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 1000 total points
ID: 39853681
just like what was suggested by Lee,
change the Data type of the field to Text if it is Number Data Type

you can use an update query to change the values


Update TableX
set [fieldname]=[fieldname] & "USABC"


or adding a where condition

Update TableX
set [fieldname]=[fieldname] & "USABC"
where <condition goes here>
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question