Posted on 1998-09-18
If I have an access db named salesinfo that has a table called table1.
just assume it has a field known as totalsales and a field known as month, and year, and also has a field salesperson.
I want to put in an array, the sales data where the salespersons name ="david" and the year="1998", and it needs to be grouped by month. (jan, feb, march, etc)
I need this data in an array, because I want to use mschart with this array. I need to understand how to do this array, so I can do similar arrays on other criteria.