General information
Category:
Coding, syntax & commands
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only