Sorry, I sent the previous message without a subject.
 
I have a table with a field that stores a revision number for each record. 
This is used for a report where I show which records have been editted 
between revisions. I do this using a query that compares two recordsets; 
one for the most recent revision number and another for the revision 
previous to it. I join these two recordsets on the primary key, then I 
compare each field between them to find where there are differences (ie.: 
qry1.field1 <> qry2.field1 OR qry1.field2 <> qry2.field2 OR ...). 
 
In the result set I get from this query, I have appended a field 
called 'Status' whose value is 'Edit'. This is used in the report to flag 
which records have been changed between revisions. What I would like to do 
is extend this 'Status' field to include the name of the field whose value 
has changed between revisions, therefore, the 'Status' field would 
read 'Edit in <FieldName>' (where <Field Name> is the name of the field 
that has been changed). 
 
I know I could use code to loop through the records, however I prefer to 
stick to queries due to the performance hit using code. If anyone has done 
something similar or has any ideas as to how I might do this, I would be 
grateful.
 
Thank you,
 
Dave