Nicholson, Karen
cyx5 at cdc.gov
Mon Jan 3 05:28:45 CST 2005
One meeting with John Colby and look how you have developed!! This is what I wanted - I do not like those compare table things that list out the field name that was changed in one column and the old and new values in another column. I want to present my user with a form showing the history of the record - it only has 10 fields. Then with my new love of conditional formatting I can highlight the changes. Wishing everyone a great new year and for a life as good as we have. Thanks to all. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Thursday, December 30, 2004 5:43 PM To: Access Developers discussion and problem solving Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com