The long and short of my filter trouble was using OrderDate from a Table.
At the risk of over explaining.. this is how it looked when I (finally) hit on the right way by using (what I think is) an Expression.
QUERY BUILDER
FIELD: CompanyName | ProductName | Sum Of Quantity: Quantity | Sum Of ExtendedPrice: | [Orders].[OrderDate]
TABLE: Customers Query | Customers Query | Customers Query | Customers Query |
TOTAL: | Group By | Sum | Sum | Where
SORT: | Ascending | Descending | |
SHOW: {checked} | {checked} | {checked} | {checked} | {unchecked}
CRITERIA: | Between #9/1/2010# And #9/10/2010#
SQL VIEW
SELECT DISTINCTROW [Customers Query].CompanyName, [Customers Query].ProductName, Sum([Customers Query].Quantity) AS [Sum Of Quantity], Sum([Customers Query].ExtendedPrice) AS [Sum Of ExtendedPrice]
FROM [Customers Query]
WHERE ((([Orders].[OrderDate]) Between #9/1/2010# And #9/10/2010#))
GROUP BY [Customers Query].CompanyName, [Customers Query].ProductName
ORDER BY [Customers Query].ProductName, Sum([Customers Query].Quantity) DESC;
pbaldy, Thanks for your effort to help.. I appreciated your time.