Maurice,

Welcome to the UT.

>
>My first issue surrounds the ability to convert the "DATE()" function into a LONG date type. I have numerous methods, but to no avail. Everytime I preview the report, I keep getting the SHORT date format.....Any ideas ???
>

Stephen already helped you here...SET CENTURY ON

>Also, I can not come up with a reasonable method for establishing proper page numbering for this report...I would like to know how to successfully implement page numbering using the "PAGE# of TOTALPAGES" format...
>

You have to run the report twice; the first time to a temporary file for the purposes of calculating the number of pages. Re: Total page count for a report Thread #644545 Message #644558 gives more details.

To get to that thread, be sure you have Autolinks turned on (it is under the options tab at the top right of the message).