Only return data from "First Occurrence" of a record?

[Former Member]

Post Author: cmainard

CA Forum: Formula

I have a table with per customer, multiple rows.

For example:

nameadd

Family

famorder

Portfolio Name Three

famsalu

sperling_dale

1

814308-3 and 618887-4

Mr. and Mrs. Dale R. Sperling

sperling_dale

2

4724042

Mr and Mrs Dale R Sperling

sperling_dale

3

4734415

Mr and Mrs Dale R Sperling

sperling_dale

4

4734416

Mr and Mrs Dale R Sperling

sperling_dale

5

4724052

Mr and Mrs Dale R Sperling

I would like to ONLY return the field "famsalu" where field "famordr" = 1

Note that the punctuation is _correct in the first record, but not in the others. I still report on the other rows, but when returning "famsalu" can I make it Always be from where famorder = 1 ?

Thanks!

[Former Member]

Post Author: V361

CA Forum: Formula

You can use the select statement, right click on your famorder field, select the select expert, your select may look like this = "1"