Date Stamp for events?

[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 rpeorts to show how long between stages for each job.

Any sugestions?

Thanks

 

[humbleprogrammer]

You can create a new table and each time an event occurs have the program insert the order number, event type, date/time in this table.

 

[maca9]

How would I make the program insert those things into the new table?

 

[humbleprogrammer]

I am assuming one of the events occur after a button on a form is pressed or some other action is taken. Write an append query that grabs the forms order #, event type and the current date/time. Then call this append query after the event is triggered.

If you paste the code that's behind one of your events, I will provide a sample for you.