Jump to content
Sign in to follow this  
Davidatlamont

Print only 1st occurence of same value

Recommended Posts

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 by Guest

Share this post


Link to post
Share on other sites

You could make a calculated field:

Case( Apt = 1 ; House )

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.