E
EMILYTAN via AccessMonster.com
I have this:-
PN AGing
1111-1111 10
1111-1111 20
2222-2222 5
2222-2222 3
In this case i would want to select 1111-1111 with aging 10, and for 2222-
2222 the aging will be 5...
I have a recset,but do not know how to continue...
mySQL = "SELECT Wardboard.PartNumber, SupplyOrderDueDate, DateToCome FROM
Wardboard "
myrecset.Open mySQL
Do Until myrecset.EOF
hope someone willing to guide me on...
PN AGing
1111-1111 10
1111-1111 20
2222-2222 5
2222-2222 3
In this case i would want to select 1111-1111 with aging 10, and for 2222-
2222 the aging will be 5...
I have a recset,but do not know how to continue...
mySQL = "SELECT Wardboard.PartNumber, SupplyOrderDueDate, DateToCome FROM
Wardboard "
myrecset.Open mySQL
Do Until myrecset.EOF
hope someone willing to guide me on...