Summing fields between two dates

[RealGomer]

I think I know how to do this but any extra help would be appreciated.

I have a table with four fields - net sales, payin date, payin number, and
payin amount. What I want to do is create a query that will summarize all of
the amounts in "net sales" within a specified date range. I thought an
expression reading SUM([net sales]) BETWEEN [start date] AND [end date] would
work, but it doesn't.
Suggestions?

 

[vanderghast]

SELECT SUM( [net sales] )
FROM tableNameHere
WHERE fieldWithDateHere BETWEEN [start date] AND [end date]


as SQL in SQL view, should do.



Vanderghast, Access MVP