Date stamps

[maca9]

Hi

What I am trying to do is track the time between certain events in the system.

For example when an order is received, assigned, approved, completed. (The actual process is far more complex.)

I would like a way of capturing when each occurs and then i could build reports to show how long between stages for each job.

Any sugestions?

Thanks

 

[jbehrne]

Hmmm... I am assuming that each record has a unique 'order number' (i.e. - some unique value for each order, like an autonumber). A quick way would be to create a table that has this:

OrderProcessingInfo -- TableName
OrderNumber -- Primary Key
receiveddate -- date/time
assigned -- date/time
approved -- date/time
completed -- date/time

Then at each point you would set the values accordingly:
When the order is received:
Me.receiveddate = Now()

When The order is assigend:
Me.assigned = Now()

etc...

You would just drop the appropriate field into each form's query (should be tied together via the order number) and trigger the event when appropriate. Hope this helps!

If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations