how to return number of rows in a table

I need to generate a report that gives a list of all "Z'ed" items ...no problem. the report must also contain a count of all of the items in the table from which I am pulling the "Z'ed" items... this presents me whith a problem as I don't want all of the items returned but i do want a count of them.

I tried using a noprint statement in conjunction with a second select but it only gave me a lot of blank pages.

Can anyone instruct me?

• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful