Dear Sir.
i have attach a file.in this for obtaining the last record i am using this code which i read in microsoft article.
Expr1: DLookUp("[MyField]","MyTable","[ID]=" & [ID]-1)
Please Check my Query where is i am Wrong.
i want to get the opening stock.
example in my file.
if you enter the start date "05-10-04" and end date "10-10-04".and if you give the code "77".it bring up one record i want in Expr1 Colum it should print the previous balance of the last date.
or what idea to obtain the opening stock
i have attach a file.in this for obtaining the last record i am using this code which i read in microsoft article.
Expr1: DLookUp("[MyField]","MyTable","[ID]=" & [ID]-1)
Please Check my Query where is i am Wrong.
i want to get the opening stock.
example in my file.
if you enter the start date "05-10-04" and end date "10-10-04".and if you give the code "77".it bring up one record i want in Expr1 Colum it should print the previous balance of the last date.
or what idea to obtain the opening stock
