Report on changed data

[Guest]

Hi,

I have created a query that returns only records with duplicate IDs from my
RecordHistory table.

My results are:

IDNumber Phase Value
88 IN 200,000
88 ID 200,000
106 ID 100,000
106 ID 150,000

I want to have the following show up on my report

IDNumber 88 Phase changed from IN to ID
IDNumber 106 Value changed from 100,000 to 200,000

I am not clear on how to view the data in sequential records (with the same
ID)
and then get this info onto the report....

Any help here is appreciated..Thanks

 

[Guest]

In this case, your best bet would be to create a GroupLevel based on ID