Refrencing another record

[BurtonBach]

I need to create a report from a table that collects the time that a
manufactured item is ready for delivery. One item I need to add to the
report is the time differential of each manufactured item sent to a specific
location. For example, Widget 1 has a ID of 1, and production time of 10:00
am. Widget 2 has an ID of 2, and a production time of 10:03. Widget 3 has
an ID of 3, and a production time of 10:07. I need a report that based on
this items falling in sequence of ID can calculate the time differential is
0:07 (Minutes). This concept is stumping me. (I don't need help with report formating or grouping, just getting these pieces of information to calculate.)

Thanks

[maxamis4]

We use this method for metrics where I work. The best way to do this is to create a seperate table with an autoid. Now you should create a field that has the particular order number to reference a field called date and a field called time stamp. You will need to use VB for this process. Every time a change is made into the particular order an insert statement will add a record to the table, based on the your order number which should be unique per widget. Another words order 123 has 12 steps, every time someone enters or a change is made to order 123, a stamp with order 123 will be made with the date and the time. you can include a stamp as well with the process name.

1. On after update call a module that inserts the stamp.

I need to create a report from a table that collects the time that a
manufactured item is ready for delivery. One item I need to add to the
report is the time differential of each manufactured item sent to a specific
location. For example, Widget 1 has a ID of 1, and production time of 10:00
am. Widget 2 has an ID of 2, and a production time of 10:03. Widget 3 has
an ID of 3, and a production time of 10:07. I need a report that based on
this items falling in sequence of ID can calculate the time differential is
0:07 (Minutes). This concept is stumping me. (I don't need help with report formating or grouping, just getting these pieces of information to calculate.)

Thanks

[BurtonBach]

Thank you for your reply. I am not very good at VB. I am interested in learning more and I'm wondering if there is an example of what your describing on the net somewhere or something I can reference to work on what you have described.

We use this method for metrics where I work. The best way to do this is to create a seperate table with an autoid. Now you should create a field that has the particular order number to reference a field called date and a field called time stamp. You will need to use VB for this process. Every time a change is made into the particular order an insert statement will add a record to the table, based on the your order number which should be unique per widget. Another words order 123 has 12 steps, every time someone enters or a change is made to order 123, a stamp with order 123 will be made with the date and the time. you can include a stamp as well with the process name.

1. On after update call a module that inserts the stamp.

[maxamis4]

I don't mean to be harsh but, VB is a long process, so start by examples, but usually what you are looking for is called an audit trail. Good luck

Example sites
http://www.fabalou.com/
http://www.databasedev.co.uk/downloads.html
http://www.geocities.com/pmpg98_pt/

example

 
CurrentDb.Execute "INSERT INTO tbl_Import_Audit (FileName, Import_Date, User, CompIP, CompName, myTime) VALUES ('" & txtFilePath & "',#" & mydate & "#,'" & myUser & "','" & myIP & "','" & myComp & "',#" & mytime & "#)"
 
 

my example includes some concepts of VB more advanced. But it will look something like that. the amper sign and quotes distinguish whether its a string or an integer (number)

Thank you for your reply. I am not very good at VB. I am interested in learning more and I'm wondering if there is an example of what your describing on the net somewhere or something I can reference to work on what you have described.