Updated data 1

[Xzibit7]

I am using a query to draw data from a large table on individual stock numbers that are inputed at different times into another table (This is an ever increasing table with new values inputed randomly). My problem is I need to be able to tell and show when certain fields in the large table are changed and to be able to show the old data and new data together, on the numbers from the smaller table. Any help would be appreciated. Thanks

 

[SeeThru]

Yuo will have to look at some kind of select query.

Add both tables and the fields you want to show.

Then add some calculate fields like

NewPrice: table1!price=table2!price

Then in the criteria set this to FALSE to show non changed records or TRUE to show changed.

If you want to do this for multiple fields, use a new OR row for each field, or use a union query.