unselected fields showing in query

[vickiwells]

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.

 

[Carol]

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

 

[vickiwells]

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.

 

[Chris RR]

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

 

[Pat Hartman]

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

 

[vickiwells]

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.