Sorry, I forgot that Rev won't allow an item of a word, so we have to
factor the month out to another function:
This is tested on some made up data, 20,000 records
function getReport pData
repeat for each line L in pData
put word 4 of L & getMonth(word 5 of L) into tKey
add word 3 of L to tTotals[tKey]
end repeat
return tTotals
end getReport
function getMonth pDate
set the itemdelimiter to "/"
return line (item 2 of pDate) of the monthnames
end getMonth
This return an array where the keys are the category/month ids in
about 100 ms on this macintel laptop.
Best,
Mark
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution