Andy D 2002
Board Regular
- Joined
- Apr 22, 2002
- Messages
- 106
Hi
Im using the query tool (data menu => get external data => new database query) to suck information in from a database.
Its returning results, see example below:
Client Name Valid to Date Size Rate
********** ********** **** *****
Client 1 01/01/2007 Size 1 110
Client 1 01/01/2007 Size 2 220
Client 1 01/01/2006 Size 1 100
Client 1 01/01/2006 Size 2 200
Client 2 01/06/2006 Size 2 220
Client 2 01/06/2006 Size 4 440
Client 2 01/06/2005 Size 2 210
Client 2 01/06/2005 Size 4 410
Client 3
etc
How can I change it so it only shows the latest set of rates for each client? eg valid to 01/01/2007 for client 1 and valid to 01/06/2006 for client 2?
(as you can see each client has its own set of sizes and rates and the renewal dates vary by client).
Hope makes sense
Thanks
Andy
Im using the query tool (data menu => get external data => new database query) to suck information in from a database.
Its returning results, see example below:
Client Name Valid to Date Size Rate
********** ********** **** *****
Client 1 01/01/2007 Size 1 110
Client 1 01/01/2007 Size 2 220
Client 1 01/01/2006 Size 1 100
Client 1 01/01/2006 Size 2 200
Client 2 01/06/2006 Size 2 220
Client 2 01/06/2006 Size 4 440
Client 2 01/06/2005 Size 2 210
Client 2 01/06/2005 Size 4 410
Client 3
etc
How can I change it so it only shows the latest set of rates for each client? eg valid to 01/01/2007 for client 1 and valid to 01/06/2006 for client 2?
(as you can see each client has its own set of sizes and rates and the renewal dates vary by client).
Hope makes sense
Thanks
Andy