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"
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"