If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access error message
I am doing a project for school and I need help. I am being asked to create
query using all catagories in table. When I chose all with asterick and them try to run query it tells me I can't set criteria for asterick. I'm confused. Can anyone help? Thanks. -- sloan |
#2
|
|||
|
|||
Access error message
Can you post the SQL you are trying to run?
If you want to display all the records, then there is no need for criteria. Select tableName.* From TableName And you cant have that Select tableName.* From TableName Where tableName.* = value You can create a criteria to a field in the table and not to all records *. -- If I answered your question, please mark it as an answer. That way, it will stay saved for a longer time, so other can benifit from it. Good luck "sloan" wrote: I am doing a project for school and I need help. I am being asked to create query using all catagories in table. When I chose all with asterick and them try to run query it tells me I can't set criteria for asterick. I'm confused. Can anyone help? Thanks. -- sloan |
#3
|
|||
|
|||
Access error message
sloan wrote:
I am doing a project for school and I need help. I am being asked to create query using all catagories in table. When I chose all with asterick and them try to run query it tells me I can't set criteria for asterick. I'm confused. Can anyone help? Thanks. The message is clear. If you pull down the top choice from the table with the asterisk after it then you cannot place criteria in that same column of the query grid. Criteria entries need to be under specific field names in the query design grid. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#4
|
|||
|
|||
Access error message
"sloan" wrote: I am doing a project for school and I need help. I am being asked to create query using all catagories in table. When I chose all with asterick and them try to run query it tells me I can't set criteria for asterick. I'm confused. Can anyone help? Thanks. -- Hi Sloan, Quick alternatve to using "*": Double-click top of your table in query designer. This will highlight all fields in your table. Drag-and-drop highlighted fields down into a field row of bottom grid. You now will have a query with all, separately-listed fields where you can add a criteria under the pertinent field. good luck, gary |
#5
|
|||
|
|||
Access error message
Gary Walter wrote:
"sloan" wrote: I am doing a project for school and I need help. I am being asked to create query using all catagories in table. When I chose all with asterick and them try to run query it tells me I can't set criteria for asterick. I'm confused. Can anyone help? Thanks. -- Hi Sloan, Quick alternatve to using "*": Double-click top of your table in query designer. This will highlight all fields in your table. Drag-and-drop highlighted fields down into a field row of bottom grid. Even faster, if you want only some of the fields, is to double-click on each field in the Table; that field is appended to the collection of fields in the bottom pane of Query Design View. As with dragging-&-dropping, you get your choice of fields (don't have to copy all of them). You now will have a query with all, separately-listed fields where you can add a criteria under the pertinent field. Besides the filter criterion, you can also specify if you want the field used as a sorting key. For sorting, you might have to list it twice, once with the "Show" box unchecked, to select the sorting keys in a different order from the way you display them. good luck, gary |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Ambiguous Name Error | pm | Using Forms | 10 | June 5th, 2005 09:19 PM |
2002 vs 2003 | Patrick Stubbin | General Discussion | 2 | May 17th, 2005 07:27 AM |
The "Right" web hosting for data access pages?? | Ron Ehrlich | General Discussion | 9 | May 6th, 2005 05:49 AM |
Book recommendations, please | Top Spin | New Users | 2 | March 1st, 2005 12:43 AM |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |