Search results for query: *

Skip, There is only a small problem though... I can't (don't know may be)show only the ones that have changed. Any suggestions? Thanks Ravek

That worked brilliant and thanks. Ravek

Hello Skip, Good suggestion of using a pivot table but the problem is maintaining all the changes in one single table. Because changes are happening in ERP table not in my Access table and i can only take periodical dumps. you wrote... "Initially Part A has 2 ops. Then on 2/15 op 10 setup...

Hello Skip, Sorry for the delay. The first instance you have shown is exactly what I want to achieve but in a columnar format like below. Part_No Op_No SetUp_Time Run_Time Snap_Date SetUp_Time Run_Time Snap_Date A 0010 0.40 0.0020 01/15/2004 0.45 0.0020 02/15/2004 A...

SkipVought, The company I am working for doesn't have the luxury of having enough resources for controlling/documenting changes like an Aerospace Industry has. But certainly our ERP system is capable. ECM module you are talking about is yet to be implemented in this medium size, market driven...

Hello SkipVought, If I haven't made my point clear, my objective is to capture the changes done to Routing Table in ERP itself, periodically. Snapshot of this table was exported and a table in Access was created before start of the project. Because once any of the fields are over written with...

Guys, Can any one please help me in figuring out how to achieve the following in Access 2002? It’s about capturing Changes done to ‘Routes’ (Machining Operations) details for a manufactured part. A table in our ERP system holds the following fields: ‘Part_No’, ‘Op_No’, ‘Start_Date’, ‘End_Date’...

Hello Waely, This is just a formatting cells issue, Highlight the Column, right click and 'Format Cells', then in Costom formats, create one like #0000. Once done, start with 0 in cell 'A1' and drag down. Hope this helps...