Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

gusbrunston

Programmer
Joined
Feb 27, 2001
Messages
1,234
Location
US
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
 
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
 
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
 
I would much rather just write the SQL. I started out with nothing, and I still have most of it.
 
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.
 
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 8-) An old PICKer, using Access2000. Celebrating this year my 72nd birthday and my 50th wedding anniversary.
padregus@attbi.com

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top