I want to create a table known as output table that gets instrument type from the classification table in the attached sample of a much larger database.
To do this the query will have to use the security name field to populate the cash instrument type and the ISIN field for the stock instrument type as the names of the stocks can be slightly different to what's in the classification table.
How can this be done in access?