I posted a question which was not very clear once the formatting was erased so hopefully this will be clearer.



I have attached a sample database which is very similar to the problem I have.

The first table lists the price of Apples, Oranges and Pears (under these column headings) each day as the price constantly changes.

The second table lists the fruit under the column heading 'Fruit' and has another column for the most recent price.

I can make a query to populate the current prices in a table with a similar format to the prices table (with Apples, Oranges,Pears as the column headings) but I need the current price for each to be populated in the Current table. I need it done this way so can reference it elsewhere in the full database. Is this possible and if so please could someone walk me through how to do it.

Thanks you very much.