in where condition

[paulwalker]

Hi Everyone,

Year, Month and TotalCost  and

current month TotalCost Max of  year

using WHERE condition

Thanks in Advance

[MayilVahanan]

Hi

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