Print only 1st occurence of same value

[Davidatlamont]

I'm fairly new to FM and have a database with addresses (only 1 table) listing addresses such as:

House Apt

44 1

44 2

44 3

However, when I print I only want to see house # (44) on first record (Apt. 1)

I assume I need to handle this in layout, but now sure how. Thanks.

Edited April 27, 2007 by Guest

[Fitch]

You could make a calculated field:

Case( Apt = 1 ; House )

... and use that field on your print layout instead of the actual House field.

[Davidatlamont]

Okay, I can see how this would work. Can I set up calculation with "or". For example, in addition to 1, 2, 3, I may also have apartment numbers such as 1A, 2A, 3A; in this case I would also like House # to print. Therefore, how do I handle multiple conditions (also for example single family dwelling where apt field is blank- house # should always print in this case)

Thanks.

[David Jondreau]

Case(Left(Apt;1) = 1 or IsEmpty(Apt); House)

[Davidatlamont]

I just figured out how to set multiple conditions, this will work great, thanks!

[comment]

Case(Left(Apt;1) = 1 or IsEmpty(Apt); House)

That will also be true for Apt# 11...19 (and Apt# 100...199, etc.). Perhaps a better test would be:

Case ( GetAsNumber ( Apt ) = 1

But I would go with a simple subsummary by House instead.

[David Jondreau]

Dang. You're right comment on both parts.