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