Summing fields between two dates

  • Thread starter Thread starter RealGomer
  • Start date Start date
R

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?
 
SELECT SUM( [net sales] )
FROM tableNameHere
WHERE fieldWithDateHere BETWEEN [start date] AND [end date]


as SQL in SQL view, should do.



Vanderghast, Access MVP
 
Back
Top