Setvalue to add 15 minutes to field

Rob · Dec 14, 2003

I am looking for the format to use the setvalue to add
minutes to a short time format field.

Many thanks,

Rob

Steve Schapel · Dec 14, 2003

Rob,

Item: [YourFieldName]
Expression: DateAdd("n",15,[YourFieldName])

You might also consider using an Update Query to do this job.

- Steve Schapel, Microsoft Access MVP