[AccessD] Count pages in a report

Thanks All

I read all suggestion but putting it in an IIF seems to be what I wanted.

With Steve's help I came up with the expression below which seems to work.



=IIF([Pages]>1,"Page " & [Page] & " of " & [Pages], "")

JOE HECHT
LOS ANGELES CA 
 jmhla at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Conklin
(Developer at UltraDNT)
Sent: Monday, November 29, 2004 8:46 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Count pages in a report

Why not in the text box record source, just put an IIF:

=IIF([Pages]>1, [Pages], "")

Steve