Summing fields between two dates

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?
--
Für Elise - Support the Breast Cancer & Heart Foundations

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


as SQL in SQL view, should do.



Vanderghast, Access MVP



"RealGomer" wrote in message
...
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?
--
Für Elise - Support the Breast Cancer & Heart Foundations