Here's an example of a useful count statement:

Scratch.mac

SELECT LIBVOLUMES.VOLUME_NAME, LIBVOLUMES.STATUS, LIBVOLUMES.LIBRARY_NAME
FROM LIBVOLUMES LIBVOLUMES WHERE (LIBVOLUMES.STATUS='Scratch')
SELECT COUNT(LIBVOLUMES.VOLUME_NAME) as "Scratch volumes" FROM LIBVOLUMES
LIBVOLUMES WHERE (LIBVOLUMES.STATUS='Scratch')

Wes Lewison
Senior Technical Programmer
Winn-Dixie Stores, Inc.
904-783-5939