Query results

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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>

Kerry S said:
I have created and ran a query. The query results showed the fields that I
Click to expand...
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?
 
Check the "Output All Fields" Property of the Query.

--
HTH
Van T. Dinh
MVP (Access)



Kerry S said:
I have created and ran a query. The query results showed the fields that I
Click to expand...
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?
 
Back
Top