Problem in Access Queries.

[JTrilloJ]

Hello:
Every time I create an Access query and before the FROM clause, it adds ,*
Is this a problem that any of you have detected?
Is there a solution?
It does this both in grouped data queries, as well as in other queries.
Example:
SELECT TblHechos.DiaSem, Count(TblHechos.DiaSem) AS Veces, *
FROM TblHechos
GROUP BY TblHechos.DiaSem;
Obviously in grouped data queries, when I want to view "Data Sheet", I receive the Error Message >> Cannot group by fields selected with ,*
Gracias anticipadas >> JTrilloJ

 

[June7]

File > Options > Object Designers > Query Design > uncheck Output all fields

Or edit the query.

 

[JTrilloJ]

File > Options > Object Designers > Query Design > uncheck Output all fields

Or edit the query.

Perfect June7: Fast, accurate and efficient.
We can consider it resolved.
Kind regards >> JTJ

 

[GPGeorge]

Hello:
Every time I create an Access query and before the FROM clause, it adds ,*
Is this a problem that any of you have detected?
Is there a solution?
It does this both in grouped data queries, as well as in other queries.
Example:
SELECT TblHechos.DiaSem, Count(TblHechos.DiaSem) AS Veces, *
FROM TblHechos
GROUP BY TblHechos.DiaSem;
Obviously in grouped data queries, when I want to view "Data Sheet", I receive the Error Message >> Cannot group by fields selected with ,*
Gracias anticipadas >> JTrilloJ

The asterisk is not a problem. It's standard SQL syntax. It means "Include all fields from the table".

June7 showed you how to remove it as a default, but it's up to you to craft queries as you need them, when you need to create them.

 

[JTrilloJ]

The asterisk is not a problem. It's standard SQL syntax. It means "Include all fields from the table".

June7 showed you how to remove it as a default, but it's up to you to craft queries as you need them, when you need to create them.

Thanks George:
It's a good point that
I will keep in mind.
The sources of knowledge always have resources to provide and expand solutions.
Translation by google
My regards >> JTJ