mysterious fields in result set

[Doug Chamberlin]

Using Access 2003 I've created a query from a linked table. I ask for
one field and sort on it ascending. When I run the query it shows all
fields from the linked table!

Also, if I "group by" the first field and add a second with "count" I
get an error that I cannot count fields if "*" has been used. However,
I haven't used * anywhere!

What's going on? How do I fix it? i want to query just selected fields
from this table and I want to summarize counts based on selected fields.

--

 

[Rick Brandt]

Using Access 2003 I've created a query from a linked table. I ask for
one field and sort on it ascending. When I run the query it shows all
fields from the linked table!

Also, if I "group by" the first field and add a second with "count" I
get an error that I cannot count fields if "*" has been used. However,
I haven't used * anywhere!

What's going on? How do I fix it? i want to query just selected fields
from this table and I want to summarize counts based on selected
fields.

In the property sheet of the query while in design view turn off the "Output all
fields" option.