Issue with window title

[#1]

Hi All,

I want to show the below title as the window title.

TOP 10 2008

where 2008 should be fetched using the expression (Max(Year)-1). Let me know how to do that.

I used below one in the expression but it doesn't work. I know it must be very very simple but i don't know here i missed out.

= & ' Top 3 ' & (Max(Year)-1)

Hope some one can help me out!

Regards,

Rikab

[Miguel_Angel_Baeyens]

Try

=' Top 3 ' & (Max(Year)-1)

[#3]

Hi Miguel!

Thanks for your quick reply. That is working perfectly. In few of my other post i have been waiting these days for your reply. When you get some some time please reply me.

Thanks and Regards,

Rikab

[#4]

I think the problem is that 'Year' is not being interpreted as a number. Try forcing it to a number using (Max(num#(Year))-1)

Regards,

Gordon

[#5]

Hi,

Not sure about your thought. But the expression sent my Miguel is working. I will check your as soon as possible and will let you know. Thanks for your help.

<pre>=' Top 3 ' & (Max(Year)-1

Regards,

Rikab