[AccessD] Tracking Changes in the Year 2004, Almost 2005

 From you all-too-brief description, I'll guess that T2 and T1 have 
identical structures, and that any change in T2 supercedes any value in 
T1 (else it gets WAY complex). But supposing that I'm correct....

One interesting way to do this is is to JOIN the tables and present them 
columnwise, i.e. T1.C1, T2.C1, T1.C2, T2.C2 etc. so you can readily 
compare the diffs. You can add criteria to specify that T1.C1 <> T2.C1 
and so on, so you only get the rows that are different in some respect. 
Once you have that and you like the output, it's pretty simple change it 
to an update query in which you set T1.Cx = T2.Cx.

I might be missing the point (wouldn't be the first time), but in my 
defence your description of the issue was a tad sketchy.

Arthur

Nicholson, Karen wrote:

>OK, so I am losing my mind.  I have a QUERY that I am going to run to
>update the records in my base table with records from my changes table.
>I want to track which fields were changed from and to.  Every example I
>pull is form based and won't run because SOMEBODY sent me an Access 95
>example.  Some of you weren't even born in 95.   Aughghghgh!    Any help
>is appreciated, as usual.
>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.6 - Release Date: 12/28/2004