I need a SQL query for Access. I have a table, Policies, with columns 'Type','Age', and 'Duration' . I have other tables Type1, Type2, Type3, and Type4. The rows for these 4 tables are 'Age' and the columns are 'Duration'. I need to use the info from the Policies table to call the correct 'Type' table, and get the data from the correct cell based upon the 'age' and 'duration'. How would I do this in a VB program?

Is there a way to do this in Access and have the results in a column in the same table or a query or on a form?

Thanks