I need to create a slx group that shows all accounts that have not had an activity in the last so many days.  The list should have on it the account information and then the last activity completed date.  One row per account.

 I can create the group and display the account information, but when I add completed date the listing changes to showing all activities for the account rather than just the last activity.

 Any help would be appreciated.

Hi,

This is because the link is a one-to-many join, as far as im aware there is nothing you can do about this within the SalesLogix query builder.

Regards, Adam Travers

Depending on your version of SalesLogix. SalesLogix does have a field called lasthistorydate. That would be the field you want to use for your group.

Dale

The only issue I can see with using that field is there will be a mismatch if a user completes a prior activity using the 'As Scheduled' button

Regards, Adam Travers