Lookup question (1 Viewer)

[KirRoyale]

I have a table which includes corporate mobile phone numbers and the phone numbers that they dialed in each call. I want to notate whether the number called is another company mobile i.e. contained in the field of company mobiles) or an external number but I don’t know how to do this. Cold somebody please point me in the right direction?

 

[CJ_London]

If your table is called tblMobCalls then you need a query along the folllowing lines - I'm assuming your mobile numbers are text and not numeric

SELECT MobNum, CalledNum, iif(dcount("MobNum","tblMobCalls","Mobnum ='" & CalledNum & "'")>0,"Internal","External") AS CallType FROM tblMobCalls

 

[KirRoyale]

CJ_London
That worked perfectly, thank you!