I'm using DB MS Access. with Vb2005.
I have this select:
" SELECT LAST(BNotice),LAST(BAgent),LAST(BPriceS), SUM(IIF(BType='Buy',BAmount,-BAmount,)),BSource,BClass,BKind,BMaterial FROM TBbills Where BType IN ('Damage','Sell','Buy') and Bmdeleted ='Yes' GROUP BY BSource,BClass,BKind,BMaterial"

I Have another Filde in the Table "TBbills Called History and it's Typed Date/Time.
I want to define the LAST(BAgent),LAST(BPriceS) according with the Last HIstory.