I have a bound subform that has one field that is grouped and then I have two fields that get sums based on that field. So I want to list all of the part numbers that were produced, for each part number I need a qty for each shift for a particular production line for date ranges like daily weekly, monthly. I get the date range and line number from the main form. Do I need to use a crosstab query, dsum, query in query? I'd appreciate the help. I might be making it harder than it is.