How to Make Pending Value Like This?

Any one like to help me here please

It's possible, if every records of ingredients have DATETIME field with different values. Example of calculated field

(
(SELECT cereal.grams FROM cereal WHERE cereal.id=subrecords.id_cereal)  
-
(SELECT TOTAL(s.gram) FROM subrecords s WHERE (s.id_cereal=subrecords.id_cereal) AND (s.date <= subrecords.date )) 
)  

Hi Kim,
In Dmitry's solution to your 'pending' question, he needs to use a row in 'subrecords' to then read itself - once to calculate the running total and once to filter all the records that are <= to the particular date of the row.
You can't DIRECTLY refer to the same table twice (it would be ambiguous) so you need to redefine it when it's referred to a second time. 
So when he writes '.....from subrecords s........', he is redefining the second use of 'subrecords' as 's' and then subsequently uses 's.id_cereal=subrecords.id_cereal.id' etc etc.  He could just as easily have redefined it as 'subrecords2' but 's' is easier!
.
As a side issue, I often redefine tables when writing a query or script - not because I'm referring to the same table more than once, but simply to save typing (such bad habits)!  Have a look at the code below:
.
select
a.record_count,
a.salutation,
a.name,
strftime('%d-%m-%y', a.joined),
b.type,
a.phone,
a.email,
a.id
from members a, model b
.
which does exactly the same as -
.
select
members.record_count,
members.salutation,
members.name,
strftime('%d-%m-%y', members.joined),
model.type,
members.phone,
members.email,
members.id
from members, model
.
Hope all of that makes sense.
Regards,
Derek.