query two tables, changing font of changes?

[michelle11_5]

Hi,

I'm quite the novice, but is there a way to build a query to compare table a
and table b and only return table a with the differences from b in red font?
or something similar?

(I am having to find the changes needed in a database by device sn, ex:
location, ip address updates etc...)

if I have two tables one being an extract from my db and one from all the
new info, can i produce a "needed changes" query with red fonts representing
the changes needed?

I hope i wasn't too confusing..
Thanks!
Michelle

 

[John W. Vinson]

Hi,

I'm quite the novice, but is there a way to build a query to compare table a
and table b and only return table a with the differences from b in red font?

Not at all easily.

or something similar?

You can create a Query returning only those records that are different.

(I am having to find the changes needed in a database by device sn, ex:
location, ip address updates etc...)

if I have two tables one being an extract from my db and one from all the
new info, can i produce a "needed changes" query with red fonts representing
the changes needed?

Might it not be better to (at least allow the option to) just update the
database with the changes?