Create a table from 3 other tables

[munday63]

Hi, i currently have three tables.

Policy table: Policy number(key),date and fund(4 possible strings of four letters)
Last Price: date, fund, last price
Next price: date, fund, next price

What would i have to do to make a table that has a policy number, date, fund, last price and next price?

Thanks

 

[neileg]

You don't need a table, you need a query. Open up a new query. Add the three tables. If Policy is not already linked to the other two via the fund field, do that now. Drag the fields you want to the grid and run the query.