wow it works!!.. however, the output seems to be incorrect. the output doubles in lines 2 and 3?
also, since I called the origTable in this new query, what is the role of the qryTotal wherein I need the summarized count as per my required output.
DATE | FIELD1 | FIELD2 | COUNT | Expr1...