If combined with Vlookup in MS Access

[excel_1317]

I am new to Access, just wanted to ensure that is below is achievable in MS Access.

=IF(IFNA(VLOOKUP(C4,$A:$A,1,0),"")=C4,"Yes","No")


So, I have 2 tables in Access, i just want to create a query which lookup Account number from in Table 1 in Table 2 and return a Yes if the account number is present in Table 2 and No if Account Number is not present in table 2. Just like above excel function.

 

[excel_1317]

You want to write a Query using Left Join.

Select 
    Table1.AccountNumber, 
    IIf(IsNull(Table2.AccountNumber), "No", "Yes") AS MyOtherColumn
From
    Table1
    Left Join Table2
    On Table1.AccountNumber = Table2.AccountNumber

Note that depending on what your ultimate aim is, you can also use the unmatched records wizard, although personally I prefer to write my own SQL.

Thanks a lot!!

 

[xenou]

My pleasure.