Return Data

[Namsha]

I am trying to create a report that automatically returns the string "Renewal for the Year" plus the next year. How exactly do I do this? Do I use a multi-data control?
I can expect anything and everything of myself;
But can only accept or reject what you have to offer!

 

[GingerR]

if you mean that you always want to calculate the year one year from today, you can put into a text box at the heading of the report:

="Renewal for the Year " & Year(Date())+1

 

[Namsha]

Worked like a charm.....thanks I can expect anything and everything of myself;
But can only accept or reject what you have to offer!