Search results

Clear Example Table Row India UK India AN87 IK98 UK YU89 PO09 Row - Home Country Column - Host Country If i Select the Home Country as India(Row) and Host Country as UK(Column) then the Output should be IK98

To ridders : Is it a linked excel table or a local table. Ans : its a local table What are the field names and datatypes. Ans : Home Country - String Host Country - String Output : String Which field is the primary key Ans: Not Sure about this - i think no primary key is...

Hi ridders - thanks for your quick reply data is in correct position - requirement is to do a matrix lookup and i did not imported the data in to access - Here is the example for your quick understanding Home Country - ROW Host Country -Column Row India UK USA India...

Hello Everyone- Glad to be part of Access Programmers i am very new to SQL in MS Access, i have some example project in my mind- here is the requirements Here is the question in Brief Example TableMatrix: India USA UK CHINA India...

Thank you so much CJ(Super moderator) i will try this and let you know am very new to access - though will try the max [

Hello - am glad to join Access Programmers - I need help in looking the country value - below is the brief in example Table Format Rows - Home Country Columns - Host Country Sno India Albania USA UK India SD87 C34 C46 C98 Albania t1...