Return 1st record

[Sidney786]

Hi,

I have list report that returns a report with several hundred records. The record ID is duplicated in the report for each condition e.g. Approved, rejected, Assess. I only want to return the 1st record for the ID. At present all records are being returned.

Any suggestions?

Thx

Sid

 

[blom0344]

The problem is with the concept of 1st. You need to know on what criteria this is based as databases usually store data without an explicit order. Can you use a date or any other field to asses the 1st for each Id.

I case of a date you would need a filter like:

[date] = min[date] for [Id]

Ties Blom