[AccessD] A database problem....looking for a solution

Mark Simms marksimms at verizon.net
Tue Nov 23 19:18:45 CST 2010


A row is inserted with contract data - 100 columns are populated.
6 months later, an "amended" row is inserted  - 10 columns are changed to
reflect updated data; the other 90 columns are null.
4 months after that, another 4 columns are changed and another "amended" row
is inserted.
 
So essentially, there is a base row, and then update rows....similar to a
log.
I see no easy way with SQL to report A SINGLE ROW with all columns that
reflects the columns changed in the amended rows.
However, inserting the first row into a temp table and then conditionally
updating using the amended rows, 
and then reporting from the temp table seems like one way to go.
 
Any other suggestions ?
 



More information about the AccessD mailing list