hi, ive got a query which finds records for todays date, but what i would like to do is loop through all the records found and update a field in each record. what i have so far is the query. i would like it to update without submiting a form or anything, just by opening the page.
thanks in advance.
deliveries__MMColParam = "0"
If (strFinalDate <> "") Then
deliveries__MMColParam = strFinalDate
deliveries__MMColParam1 = "0"
If (FormatDateTime(Now, 4) <> "") Then
deliveries__MMColParam1 = FormatDateTime(Now, 4)