Hi,
sorry if I post in the wrong place..It's my first post.
I have a recordset like that
CODE TYPE QTA DATE
AAAA 1111 20 01/03/2011
BBBBB 2222 90 02/01/2011
I already have on a variable ad indications about a quantity. For example qta=100
I need to read this records and retrive the older date (in this case 02/01/2011) and chech qta.
If the qta is lower that the qyantity saved on my variable (in my case 100) write this line and that analyze the next recordset in order to subtract the quantity..
in my case 100 it's my quantity
I need to do:
100-90 (from BBBB article)=10
20 (from the AAAA code)-10
How can I do that?
Thanx
sorry if I post in the wrong place..It's my first post.
I have a recordset like that
CODE TYPE QTA DATE
AAAA 1111 20 01/03/2011
BBBBB 2222 90 02/01/2011
I already have on a variable ad indications about a quantity. For example qta=100
I need to read this records and retrive the older date (in this case 02/01/2011) and chech qta.
If the qta is lower that the qyantity saved on my variable (in my case 100) write this line and that analyze the next recordset in order to subtract the quantity..
in my case 100 it's my quantity
I need to do:
100-90 (from BBBB article)=10
20 (from the AAAA code)-10
How can I do that?
Thanx
