when criteria is set to waiting endtime to be clear (1 Viewer)

murray83 · Jun 2, 2017

i have got a macro which when the status is updated to done it sets the endtime to now()

but i would also like the reverse when it is changed back to waiting its blank

suggestion on an electronic post card

cheers all

Gasman · Jun 2, 2017

Care to show the macro?

murray83 · Jun 2, 2017

of course it uses the create data macros and i used the before change

Code:

If [main].[Status] = Done Then
Setfield
name EndTime
Value Now()
End If

Gasman · Jun 2, 2017

I've only used macroes so far for batch type jobs, ie running a few queries one after the other.

Would you not just add to that macro along the lines of

Code:

else
Then Setfield
name EndTime 
Value Null 
End If

I would have thought that it needed to run AfterChange?

when criteria is set to waiting endtime to be clear (1 Viewer)

murray83

Games Collector

Gasman

Enthusiastic Amateur

murray83

Games Collector

Gasman

Enthusiastic Amateur

Similar threads

Users who are viewing this thread