Select detail by latest date.....

[robmason10]

Hi there - I will start with an apology for my own ignorance!

I need to select data from an address-based table - the table has more than 1 entry per client as it stores histrical addresses. I need to select the address with the latest date (which is identified in a field called {date_from}.

How?

 

[synapsevampire]

Group by client and sort by the address date descending.

Now place the date in the client group header, and that's the latest address.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[synapsevampire]

Typo:

"Now place the date in the client group header, and that's the latest address."

Should be:

Now place the data in the client group header, and that's the latest address.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[robmason10]

Very clever - called 'Thinking outside the box' I think!

Thanks a bunch!

Rob