Hi. Well I use the Unmatch querie wizard and it workd for me.

You have to tell to the wizard witch foeld he has to compare.
Marco


"fishtofly" wrote:

I tried using the query wizard to create an unmatch record query but it did
not work. For the field of tag_id in my2003, I used the query wizard and
wrote"[my2003]![tag_id][monitor2003]![tag_id]". It came up with all the
records in the table of my2003. I need the unique tag_id's that are in
my2003 and not in monitor2003.

Any help would be greatly appreciated.

Thanks

"Ofer Cohen" wrote:

Use the query wizard to create an unmatch record query that will list all the
records in my2003 but are not listed in monitor2003

--
Good Luck
BS"D


"fishtofly" wrote:

I have two tables and both have a field called tag_id. The first table
"my2003" has about 5000 records. The second table "monitor2003" is a subset
of table "my2003" and has about 3000 records. I need help building a query
that will give me the records in table "my2003" where the "tag_id" field is
to the "tag_id" field in the "monitor2003" table. Also which type of
joining of the two tables is needed?