Data from latest date, from 2 tables

[#1]

Hi,

I have 2 tables (rates and rates_date). Rates includes historical rates for a price and rates_date includes the date connected for each rates.

What I want to pick out now is the rates with the latest rates_date, I hope someone can help me with this.

[#2]

Hi,

Sort it in reversed order.

Also, you can have list box of Dates in descending order.

Just click on latest date and you will get respective Rate.

Happy Thoughts

[#3]

Hi Fredrik,

please provide a short data extract we can work with.

Thank´s.

Rainer

[#4]

Hi,

Sorry, forgot to say that I want the result in a new column in an new table. Like this:

1) Find the latest rates_date

2) Pick out the rates that is connected to the rates_date and import that to the column "Rate" (in the new table)

Is there any function that I can use that can do this?