Loading the most up to date Account history

[#1]

Hello,

I'm hoping this will be a relatively simple query. I have a large amount of data and I only want to load the most up to date information. Table 1 belows shows an example of what I currently have, and basically I only want the latest DateChange data to come across, which is shown in Table 2. It seems to be an easy concept however I can't think of what to do in the script.

Thanks

Table 1

AccountNo	DateChange	Tariff
AB123456	05/02/06	HE
AB123456	04/08/10	E7
CD123456	02/01/03	HE
CD123456	05/04/07	E7
CD123456	08/09/09	HE
EF123456	02/03/07	HE
GH123456	02/05/08	E7

Table 2

AccountNo	DateChange	Tariff
AB123456	04/08/10	E7
CD123456	08/09/09	HE
EF123456	02/03/07	HE
GH123456	02/05/08	E7

[#2 · Accepted solution]

Check out this attached application.

- Sridhar

[#3]

That's great sridhar24784, many thanks for this.