in where condition

paulwalker — Wed, 04 Dec 2013 14:30:35 GMT

Hi Everyone,

Year, Month and TotalCost and

current month TotalCost Max of year

using WHERE condition

Thanks in Advance

Re: in where condition

MayilVahanan — Wed, 04 Dec 2013 14:47:41 GMT

Try like this

Edit:

Load * from table where match(Value,'007A','008C') ;

//and Year = Year(Today()) and Month = Month(Today());

current month opening stock Max of year-Month <- can you explain about this