i have a recordset created by a sql statement., the recordset is assigned to a datacontrol
i am trying to find a way to move throught the recordset and sum one of the fields.
i triedthe following code but nothing happen
while not datcheck.recordset.eof
total = total + amt
this worked for the date field... but i want the amt field