Access error message

[Guest]

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.

 

[Guest]

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 *.

 

[Rick Brandt]

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.

 

[Gary Walter]

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

 

[Vincent Johns]

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.