Hi guys.
Please help me to create a query between 2 tables. I am new to Access.
Table 1 : CB_Data (from Branch)
Table 2 : CB_Payment_Info (Country Duty Paid Data)
I need to verify whether "code_2" product charges already paid by country or not. tried IIF function,it doesn't work
IIF( [CB_Data]![Code_2] = [CB_Payment_Info]![Code_2] ,"Paid","Pending") .
Thanks in Advance.