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



Comments

Post a Comment

Popular posts from this blog

Getting ErrorCode: 120018 when trying to access Microsoft account - Microsoft Community

-
split thread. hi, we 've got user exact same issue: "ce mot de passe été utilisé trop souvent dans le passé. choisissez une chaîne plus difficile à deviner. (which means: " we've seen password many times before. choose harder guess. ") errorcode: 120018 correlationid: 4ab3a486-a11a-4ead-983c-c1c391c3e7d5" it happens when tries update password "login.microsoftonline.com" portal. we tested more 5 different new passwords (passwords never seen before). office 365 synchronized ad; user's account not locked or whatsoever, account set able change password cannot reset it. thanks in advance. ***post moved moderator appropriate forum category.*** hi all,   thanks replies.   generally, password length greater 10 characters. understand users may want have longer passwords. please submit feedback improve our products , services. understandi...
Read more

i need Access database tutorial books recommendations - Microsoft Community

-
hi want recommendations on access books deals table design , table relationship. have been having trouble understanding how pick fields tables when design databases example how figure out fields order , order details tables, see examples , felt have putting many order details in order table. want book or deals comprehensively topic. there tons of great books available, learns differently.  some need read, need see, ... something like https://www.amazon.ca/gp/aw/d/1119074770/ref=mp_s_a_1_2?ie=utf8&qid=1505659406&sr=8-2&pi=ac_sx236_sy340_fmwebp_ql65&keywords=access+visually&dppl=1&dpid=51osglevw8l&ref=plsrch may feet wet. there tons of great websites, like http://www.utteraccess.com/forum/index.php?showtopic=1998783 http://www.accessmvp.com/strive4peace / i'd recommend @ youtube, have done great materials can follow along, pause, replay, on , on until it. ...
Read more

accelorator feature - Microsoft Community

-
accelerator feature not compatible windows 10 causing computer load programs slow,  need download link correct problem moved from: internet explorer / internet explorer 10 / other/unknown hello sharon, starting windows 10, version 1703, accelerator can no longer used in internet explorer. can check article to learn more said setting. let know if have other concerns. regards. Internet Explorer / Internet Explorer 11 / Windows 10
Read more