
Originally Posted by
rpeare
That doesn't really answer my question. How do you know something was corrected? what is your trigger for an item to appear in your report? If you can identify when something is placed on and when something is taken off your report by looking at the data you might be able to do something with exporting to a formatted excel file.
Let's say this week items 1 and 2 appear on the report.
Next week item 2 and 3 appear on the report.
I have got to assume there is some piece of data that is identifiable to tell you whether a correction has been made or it'd be impossible to get different results from week to week, so is the field that identifies the 'uncorrected' items a date field? is it just a yes/no? what's the mechanism?
Similarly how do you know something should appear on this report? For instance, let's say you have a correction due on an item, part of your data entry is to record the date the correction is noticed, then when the item is actually corrected you record the date it was completed. If you're doing that, it should be possible to identify via formula on an excel spreadsheet which rows need to be highlighted without comparing to last week's report.