Setvalue to add 15 minutes to field

R

Rob

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

Many thanks,

Rob
 
S

Steve Schapel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASK Field Formatting 1
setting the argument in SETVALUE Action of macro 6
Where did the SetValue action go? 5
Unable to use Setvalue 1
SetValue in Access 2007 2
setvalue macro 1
trying to use SetValue but can't seem to get my database trusted 2
SetValue for a Toggle Button on a subform 1

Top