First, I have a table with a lookup field containing a list of items, and start date, end dates fields. It is possible (and very likely) the user would select an item from the drop-down list more than once in the table with start and end dates for each. For instance,

Lookup StartDate EndDate
In queue 2/3/06 2/5/06
Working 2/5/06 2/8/06
In queue 2/8/06 2/9/06

I then have a query that runs to show the total number of days for each row. It would look like this:

Lookup StartDate EndDate TotalDays
In queue 2/3/06 2/5/06 2
Working 2/5/06 2/8/06 3
In queue 2/8/06 2/9/06 1



What I need is to get totals for the matching fields in each category.

In other words, if I were to push a "total" button, I would want it to show me a total of 3 days for In queue, and 3 days for Working.

The catch is that this is a subform. Each record has a subform with multiple instances of these multiple instances!

Can anyone help or give me an idea where to turn?

Thank you in advance,
Anne Lieder