Update Query to add brackets

[Bookmdano]

I need to add brackets [] to the beginning and end of a set of 4 numbers.
Data looks like 1234
Needs to look like [1234]

Can this be done in a simple update query?

 

[Mr. B]

Assuming that your field is a test type field (which it would have to be),
use the following in the update area of your update query:

UPDATE tblTestOnly SET tblTestOnly.TestField = "[" & [TestField] & "]";

Change "tblTestOnly" to the name of your table and the "TestField" to the
name of your field you are updatting.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[Bookmdano]

Your are the man!!!!

Thanks!

Assuming that your field is a test type field (which it would have to be),
use the following in the update area of your update query:

UPDATE tblTestOnly SET tblTestOnly.TestField = "[" & [TestField] & "]";

Change "tblTestOnly" to the name of your table and the "TestField" to the
name of your field you are updatting.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

I need to add brackets [] to the beginning and end of a set of 4 numbers.
Data looks like 1234
Needs to look like [1234]

Can this be done in a simple update query?