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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Concatenating in Access Query but keep field length 1

Status
Not open for further replies.

jacquid

MIS
Nov 7, 2000
27
US
I would like to know if it is possible to concatenate fields in access and retain there field size.

For example:
Product_code length = 10 value = AIMS
Language length = 3 value = AFR

When I concatenate the fields in the following manner:
[Product_code] & [Language]
I get:- "AIMSAFR"

What I want is:- "AIMS AFR"
 
This is not pratical in the general case. If this is a limited/short term need, you CAN accomplish it, providing you 'know' the field lenght(s)

Using your example:

NewField: Left([Product_Code] & Space(10), 10) & Left([Language] & Space(3), 3)



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top