Query returning too many fields; more than selected in the query.

[MikeT]

I'm learning Access (2003) and I've built a couple of test DB's for which I'm now trying to enter and validate data. I created a query which selects only one field from each of two tables, joined by a third junction table (many-to-many). They appear to work and return the two selected fields, but they return too much info; more than just the two selected fields; they also return all fields in both tables. I thought that Access was supposed to return only the fields that were selected in the query. Why am I also getting all the other fields from both tables? How do I get Access to display only the selected fields?



I found that once I've run the query I can right-click on a field in the query results and hide it. But once it's hidden, there's no option to unhide it. How do I unhide a hidden field?

Thanks.

[MikeT]

Okay, I think I figured out how to unhide the hidden fields, but my original question remains. Why is Access showing all fields when I only selected two fields in the query design? Does Access always show all fields in a table regardless of what you specify in the query?

Thanks.

[cam2era]

Mike,

Did you ever get an answer to your question? I'm having the same problem. I've been using earlier versions of Access for years, but only encountered this when I upgraded to 2010.

-Ernie