| re: Field compare report
Ken Smith wrote:[color=blue]
> Can someone tell me how to do a compare of two different fields in two
> different tables to generate a report which will tell me what values are
> missing?
>
> I have two tables, one is the values that should have gotten imported into
> a system and the other is the ones that are actually in there. There's 250
> some odd that didnt make it (out of 10,000) and I'm trying to track them
> down.
>
> So if tbl1fld1 contains all the values that I wanted to be in there and
> tbl2fld1 is the same as tbl1fld1 minus the 250 missing values I need to see
> exactly which ones are not in there.
>
> Hope that made sense, and thanks.[/color]
If you are talking about rows (records) then yes, there is an easy
method. I'll assume there is something unique about each record...a
primary key or unique value in one of the fields (columns). If so, go
to the database window and click Queries/New/FindUnmatched wizard.
Follow the steps and voila, instant report of the missing records.
| 
