Concatenation in Access 2016 - Microsoft Community

is there way concatenate 2 fields , have data show, not dataid's!? have figured out how fields numbers, not actual data. 

here's set up: 

left([tblmaster_inventory].[countryid],3) & left([tblmaster_inventory].[datatype],1))

current answer:   

11

12

13

21

wanted answer:

afrf

afrw

afrs

camf

any advice appreciated! thanks!

expand on duane's answer. countryid , datatype, appear lookups against lookup tables id values stored foreign keys. need include lookup tables in query , pull values description fields in lookup tables.

Office / Access / Microsoft Office Programming / Office 2016