Month To Date Expression

Month to date would be (assuming PostMonth is a date field):
MTDSales:
Sum(Abs(Format([PostMonth],"yyyymm")=Format(Date(),"yyyymm"))*[CommVolume])
--
Duane Hookom
MS Access MVP


"claudia" wrote in message
...

Thanks to the group, I was able to set up an expression in my query to
report year to date sales... but still hung up on Month to date
This is the expression for YTD... any modification suggestions to
report Month only?

04YTDSales: Sum(Abs(Year([PostMonth])=(2004))*[CommVolume])

CommVolume is our commission paid $$..
PostMonth is date commisssion was paid mmmyyyy format
I want my report to show a field w/current month & year to date
THANK YOU !!!!!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/