Printing Question

[Cobby1812]

Background
I have created a Statement report. The report is per person and a statement can run from 1 page to multiple pages. The page numbers are reset at once a new name appears.

Problem
In order for this to go through the letter folding machine I need to be able to set a symbol to denote that this is the first page or last page. For instance

If a report is one page then show '***'
If the report is multiple pages then Page 1 = '*' and last page would equal '***'.

Anyone know how I can do this.....please help me before I go even more mental.

Many thanks

 

[kskid]

Try this formula

if TotalPageCount = 1 then "***"
else if TotalPageCount > 1 and PageNumber = 1 then "*"
else if TotalPageCount > 1 and PageNumber = TotalPageCount then "***"

 

[lbass]

Do you only need the symbol on the first and last pages? If so, try this:

if pagenumber = totalpagecount then
"***" else
if pagenumber = 1 then
"*"

-LB

 

[Cobby1812]

Wicked...both work great thanks very much you have made an old man very happy.