In access something like:

SELECT VOLUMES.VOLUME_NAME, VOLUMES.PCT_UTILIZED, VOLUMES.STATUS,
VOLUMES.ACCESS, VOLUMES.PCT_RECLAIM, VOLUMES.LAST_WRITE_DATE,
VOLUMES.LAST_READ_DATE, VOLUMES.CHG_TIME, VOLUMES.STGPOOL_NAME
FROM VOLUMES
GROUP BY VOLUMES.VOLUME_NAME, VOLUMES.PCT_UTILIZED, VOLUMES.STATUS,
VOLUMES.ACCESS, VOLUMES.PCT_RECLAIM, VOLUMES.LAST_WRITE_DATE,
VOLUMES.LAST_READ_DATE, VOLUMES.CHG_TIME, VOLUMES.STGPOOL_NAME
HAVING (((VOLUMES.PCT_UTILIZED)>0))
ORDER BY VOLUMES.ACCESS, VOLUMES.STGPOOL_NAME;

>>> joni.moyer AT HIGHMARK DOT COM 01/12/2006 2:07:36 PM >>>
Hey!

I was just wondering if it is possible to create a report that includes
all
offsite tapes, database tapes and backupset tapes within 1 report?
And
then total all 3 amounts for 1 final count?  I have 3 separate one's
right
now, but i'd like to be able to combine them all.  Thank you in
advance!

********************************
Joni Moyer
Highmark
Storage Systems, Systems Programmer
NEW NUMBER: (717)302-9966
NEW FAX: (717) 302-9826
joni.moyer AT highmark DOT com
********************************