query two tables, changing font of changes?

  • Thread starter Thread starter michelle11_5
  • Start date Start date
M

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
 
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?
Click to expand...

Not at all easily.
or something similar?
Click to expand...

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?
Click to expand...

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