Concatenate 1st Two Letters + Another Field

[CharlesWhiteman]

Hello All, yet another seemingly complicated question which appears to go unanswered in all 250 threads searched and read.

In my tblcompanies = [CompanyName] i.e. Microsoft Access Limited
I also have a [CompanyCode] i.e. 100

What i am really stuck with is concatenating the first two letters from company name and concatenating with the company code to provide

[AccountNumber] = MI100

And having spent £80 on reference books can still find no reference to concatenating parts of a word.

Has anybody done this and who could offer a glimmer of hope?

 

[pbaldy]

Left(FieldName,2) & OtherFieldName

 

[CharlesWhiteman]

That was annoyingly easy! however thank you for the pearl of wisdom which I hope goes on to help some others too.

 

[musclecarlover07]

I need some help with this. Im trying to create a customer ID using the first 2 letters of a last name and the last 4 of a persons SSN. I got the formula in a query. The only problem is i have 2 datasheets an all the data sheets have a last name. Hod do add in to my expression the data sheet i wish to use. I want toit to use the Last Name in my datasheet named Customer_Data. This is the expression I have
Expr3: Left([Last Name],2) & Right([PER_SSN_ID],4)

The nameing of the fields are like that because im testing my db before I use it. We pull three reports from a website then I just imported the info an for test purposes I used the heading in the excel an let access name everything. Until I get the db working 100% this is what im working with. When I reacyhed 100% perfection I will redo all an clean it up.

 

[pbaldy]

If you're saying there are multiple tables in the query:

Expr3: Left(Customer_Data.[Last Name],2) & Right([PER_SSN_ID],4)