Report on changed data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
In this case, your best bet would be to create a GroupLevel based on ID
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text Box to Pull Current Selected Information on a Report 3
DMax on existing record to increment serialized # fails 1
Editing more than 1 table at a time with SQL. 6
Grouping based on minimums 3
do not repeat section headers with each record 1
Sum Field 1
Reports that sift records from different tables 0
Highlight a row in a subreport based on matching value in main report 3

Back
Top