Query results

[Guest]

I have created and ran a query. The query results showed the fields that I selected to be displayed, but when I scrolled to the right, the other fields in my table were displayed as well, even though I did not select them. What am I doing wrong?

 

[Ken Snell]

If they're showing, it means you selected them to be displayed. Post the SQL
of the query here so that we can see what it is. Chances are that you
included a Tablename.* as a field in the query without meaning to do so.

--

Ken Snell
<MS ACCESS MVP>

I have created and ran a query. The query results showed the fields that I

selected to be displayed, but when I scrolled to the right, the other fields
in my table were displayed as well, even though I did not select them. What
am I doing wrong?

 

[Van T. Dinh]

Check the "Output All Fields" Property of the Query.

--
HTH
Van T. Dinh
MVP (Access)

I have created and ran a query. The query results showed the fields that I

selected to be displayed, but when I scrolled to the right, the other fields
in my table were displayed as well, even though I did not select them. What
am I doing wrong?

 

[Guest]

Thank You both ! Problem Solved !