Format Page number decimals

[nosajld]

Greetings -

I have the following formula:

if pagenumber = totalpagecount then
'Page 1 of ' & totalpagecount
else
'Page ' & PageNumber +1 & ' of '& Totalpagecount

The formula works fine for what I want it to do with one exception. The 'PageNumber' and 'TotalPageCount' items print with 2 decimal places each. I've tried the Round() and Fix() to no avail per the example below.

if pagenumber = totalpagecount then
'Page 1 of ' & fix(totalpagecount,0)
else
'Page ' & fix(PageNumber +1,0) & ' of '& fix(Totalpagecount,0)



Any assistance is greatly appreciated.

Thank you!

Jason

 

[swiss2007]

Not sure what you are trying to do
but to get rid of decimals use


if pagenumber = totalpagecount then
'Page 1 of ' & totext(totalpagecount,0,"")
else
'Page ' & totext(PageNumber +1,0,"") & ' of '& totext(totalpagecount,0,"")

 

[nosajld]

thanks - I will try that.

Essentially what is happening I need the page footer to be the first page of the report - so when printed out it is listed as 'page 1 of x.' On a major time crunch and don't have the time to go back and make major changes so need a quick fix.

Thank you!

 

[nosajld]

Sorry - Report footer not page footer. It worked. Thank you!