Thanks for the code snippet, i used some of it as a quide but i am
sill getting problems.
I am using the code below that works sometimes, but not other times.
For example, in one record in the db the date is 06/03/2002 but History
is not put into the per_f2 field but the following record has the date
13/03/2002 and it does have History in per_f2. Then when adm_history
was set at 28 it changed some entries with the date 04/05/2002!! do
you know what might cause this inconsistency??
~M
adm_date = date
adm_history = 7
Do Until adm_RS.EOF
adm_tempdate = trim(adm_RS("per_edate"))
If datediff("d",adm_tempdate ,adm_date ) > adm_history Then
adm_RS("per_f2") = "History"
adm_RS.Update
End If
adm_RS.MoveNext
Loop
Go raibh maith agat
~M