query returns with more columns than included

M

MorningStarFan

Hi,

We've noticed on a couple of our queries that when we run the query we get
all the columns in the table. However, in design view we see that we have not
selected all columns. Anyone know why this happens???
 
K

KARL DEWEY

Open the query in design view, click on menu VIEW - SQL View. Look at the
SELECT statement and see if there is something like this --
SELECT YourTable.*,
or
SELECT *,
If so, then delete the TableName.asterisk or asterisk.
 
Top