Query returns all records not just selected

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marg - 13 Jul 2006 14:21 GMT

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

Reply to this Message

Rick Brandt - 13 Jul 2006 14:34 GMT

> 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
[quoted text clipped - 6 lines]
> Why does it put the ,* at the end of your selection?
> Thank you

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

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message