Too Many Fields

[one3nine0]

I want to run the Unmatched Query Wizard with a table against the result of another Unmatched Query.

When I do this, an error pops up saying "Too Many Fields".

But when I run it the other way, the Unmatched Query result against the same table, it will run fine.

The table has 19 columns, and the Unmatched Query result has 18.

Any suggestions on how to successfully run the wizard?

PS I have tried to compact&Repair but does not seem to be helping.

 

[mole999]

are you doing that a s a UNION qry

 

[one3nine0]

No its a left join where a match_code is null in the query result.

Anyway I think I figured it out.

The query result i was trying to run the unmatched query against was a select query (not a make table) pulling from multiple other queries. And I think that it added up all the different queries together instead of just the final result i was querying against, resulting in too many "columns"

I created a table to query against instead and it worked fine.