Where does the * (asterisk) come from in my queries?

[gusbrunston]

Hi.

I've been curious and have encountered some little difficulties in designing queries: some gremlin *<| keeps putting an asterisk in the SQL view of the select statement and I get all the fields in a table whether I want them in my query or not. Is it because of relationships?

Is this Access2000 default?

It's easily fixed: I just delete the asterisk and it's comma in SQL view and voila!

But why do I have to?

Gracias.

Gus Brunston
An old PICKer, using Access2000
padregus@home.com

 

[Smitty020]

The asterisk in queries can mean that all of the attributes in a certain table have been selected.

For instance, SELECT * FROM Employee, would select all of the attributes in that particualr table(Employee)

hth,
Smitty

 

[gusbrunston]

Thanks, Smitty!

I've been thinking about this over a fried egg sandwich, and I now think that I get the asterisk when using the query wizard, and I select to &quot;Show every field of every record.&quot; So, I've been putting the asterisk in myself by my answer to the wizard.

Oh, well...





Gus Brunston
An old PICKer, using Access2000
padregus@home.com

 

[jhall156]

I would much rather just write the SQL. I started out with nothing, and I still have most of it.

 

[montrose]

The * obviously prevents you from setting criteria in your query. Instead of typing away in sql view, you can just open a new blank query in design view, Show the tables/queries, dbl click on the one(s) you want to use in your qry. Dbl click on each field you want in the qry and they'll appear in your grid. HTH Learn what you can and share what you know.

 

[gusbrunston]

Hi.

For any who look at this in the future:

In Tools -> Options there's a place to check off &quot;All fields displayed in queries&quot; or something like that. Mine was checked and now it's unchecked. ez Gus Brunston An old PICKer, using Access2000. Celebrating this year my 72nd birthday and my 50th wedding anniversary.
padregus@attbi.com