SELECT lic_num, ;
priv1 + priv2 + ... + priv10
FROM mytable
>I was wondering if anyone could give me a second opinion on the best way to do this report.
>
>This is an old system written in 2.6 then imported to 6.
>
>The table -
>lic_num c(15)
>priv1 c(3)
>priv2 c(3)
>.
>.
>.
>priv10 c(3)
>
>For each record, the person can have up to 10 privileges populated as a number in priv1 - priv10.
>
>The report has 3 columns, life to date, year to date, and month to date.
>
>What is the best/fastest way to cycle through each record and each priv?
>I would like the report to say, 76 was sold 30984 ltd, 3000 ytd, and 359 mtd. The codes could be in any priv1 - priv10.
>The database itself has over 70000 records so I'm worried about time.
>
>My first thought was to separate the privs into a new table with one column called priv then do a total on priv. There has to be an easier way!!!
>
>Thanks for you time,
>Sunshine
--sb--