I have three ODBC tables linked to my database. When I use them in a query, the datasheet shows all the fields in the table, not just the ones I selected. None of my other linked tables (dbf and Excel do this).I'm now getting the error " Too many fields defined" when I run the query,and wonder if these extra fields are the reason. If so, how do I get rid of them? I've compacted the database, and that didn't fix it. Would appreciate any ideas.

Look into the following:

Are my joins performing correctly

Is my criteria stated correctly

and

If duplicate records are involved, should I be using some grouping or totalling for the query

The joins are automatic, they are joined in the ODBC database. The number of records showing isn't the problem, it's the number of fields. I'm only using 4 fields from the tables, but 50 or more show up in the datasheet.

What's the underlying database? Can you post your query?

Look under Tools/Options - somewhere is a checkbox that says something like "include all fields" - that may be causing the problem.

Thanks, I think that may have done it. It didn't fix the existing query, but when I started a new one, it worked correctly.