Hello All,

I have a listbox that has values the user can sort on. I'm grabbing the first three values to use for Totaling. For Example (ProdID, Product, Date)

Then I'm loop through a recordset that has the data to be reported.

My Question:

How do I loop through this reocordset and grab each value above and total each of them? Each time the value above changes it put a total line.

Is there an easy way to do this?

I can get one value to work but not more than that at the same time.

Any help would be great!!!