query returns with more columns than included

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

Guest

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???
 
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.
 
Back
Top