I have created a view from a pivot table query that groups
data by date and by a 'code' field.

Whenever I query the view with a date range and try to
group the data by the 'code' field only (I'm not returning
the date as part of the resultset), not only do I get a
record for each date in the view, the data being
summarized appears as a running total over the date range.

Does anyone have any insight as to why the result set
appears this way?

Thanks

John