Unmatched query question

[Ellen]

Hello,
I've run a "find unmatched query wizard" as I need to
establish a one-to-many relationship. In this query,
however, I've found some numbers that are common to both
tables. I even copied one of the values from one table to
the other to be sure it was identical in both tables. But
this number still comes up in the "unmatched query".

Does anyone have any idea as to what's happening?

Thanks in advance,
Ellen

 

[Ken Snell]

Don't know...can you post the SQL of the query that you're running? Open the
query in design view, then switch to SQL view (icon in top left corner of
toolbar). Copy the entire statement that you'll see in the window and paste
it here.

 

[Ellen]

Thanks for responding, Ken. I had mixed up the fields
that were common to both. Now that that's been corrected,
everything looks good!

Ellen