How to show field'sStarting Value only on a text box

[#1]

HI,

Is there anyway to show the starting value of a Field Selection when slelecting three or four values on a text box.

[jagan · Accepted solution]

Hi,

Try this, it works for me

=SubField(Concat(DISTINCT MonthYear, ',', Date), ',', 1)

MonthYear - is my Month field

Date - is my Date field from which Month is arrived.

Regards,

Jagan.

[#3]

This work perfect..Thxs,

How can I show on another text box the last selected value?

[jagan]

Hi,

Try this for getting the last value.

=SubField(Concat(DISTINCT MonthYear, ',', Date), ',', GetPossibleCount(MonthYear))

Hope this helps you.

Regards,

Jagan.