Hi,

I try to do a report where one of the value can be double or triple.

For example : name, birthday, fonction

The name and the birthday come from the table : USER.

Fonction come from the table : ACTIVITY.

The fonction can change.

For example :

table USER :

NAME1; 01/01/1997

NAME2; 09/06/1948

NAME3; 26/11/1964

Table ACTIVITY :

NAME1; FONCTION1; 12/03/2007

NAME1; FONCTION1-1;24/07/2007

NAME2 ; FONCTION2 ; 15/06/2000

NAME3 ;FONCTION3 ;01/01/1996

NAME3 ;FONCTION3-1 ;01/01/2000

NAME3 ;FONCTION3-2 ;01/01/2007

So, for one user, we can have one or more activities.

In my report I want only the last activity so :

For NAME1 : FONCTION1-1

For NAME2 : FONCTION2

For NAME3 : FONCTION3-2

Do you know how can I do that.