formula to identify first occurence (record) only

[kbhmc]

Trying to display a date range for the first occurence of a record. Records may or may not have multiple occurences of a data element.

 

[lbass]

You haven't really provided enough information. I'll take a guess. Go to report->selection formula->GROUP and enter:

{table.date} = minimum({table.date},{table.groupfield})

This would return the earliest record per group.

-LB

 

[Madawc]

As lbass said, we need more data. Sometimes you need a set of formula fields to assemble an answer that could be based on several different fields.

Remember to start with isnull, when checking for any value that may be null.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10