Comparing two SubReports and adding conditional formatting

[JuniorWoodchuck24]

I have 2 subreports that are comparing information and I want it to flag the newest version if a change has been made. For example:

1st SubReport is record of 2009 Car Models
Engine
MPG
Cost

2nd SubReport is record of 2010 Car Models
Engine
MPG
Cost

So lets say that in 2010 the cost and MPG stayed the same but the Engine changed (I know the other 2 wouldn't stay the same, but lets just say it did in this case). How would you flag the Engine (BackColor = vbYellow)? Is there a way to go row by row and compare the two subreports if they are in the same order?

 

[Galaxiom]

Include the data from both reports as separate fields in the recordsources of the subreports. Only include controls to display the fields you require in each report.

The conditional formatting can use the fields that are not displayed.