Query returns all records not just selected

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

Guest

In my query I'm selecting 3 fields from a table but when I run the query it
returns all fileds from table. When I view the SQL it shows
SELECT Tbl_DRA_2005_2006.School, Tbl_DRA_2005_2006.Counter,
Tbl_Tenex_2005_2006.Race, *
FROM Tbl_DRA_2005_2006 LEFT JOIN Tbl_Tenex_2005_2006 ON
Tbl_DRA_2005_2006.StudId = Tbl_Tenex_2005_2006.StudID
ORDER BY Tbl_DRA_2005_2006.School;

Why does it put the ,* at the end of your selection?
Thank you
 
Marg said:
In my query I'm selecting 3 fields from a table but when I run the
query it returns all fileds from table. When I view the SQL it shows
SELECT Tbl_DRA_2005_2006.School, Tbl_DRA_2005_2006.Counter,
Tbl_Tenex_2005_2006.Race, *
FROM Tbl_DRA_2005_2006 LEFT JOIN Tbl_Tenex_2005_2006 ON
Tbl_DRA_2005_2006.StudId = Tbl_Tenex_2005_2006.StudID
ORDER BY Tbl_DRA_2005_2006.School;

Why does it put the ,* at the end of your selection?
Thank you
Click to expand...

In design view open the property sheet. There is an option to "output all
fields". Set that to No.
 
Back
Top