Query with calculations

[gtsolid]

I produced this script

SELECT Nuovo.Complessivo, Count(Nuovo.Complessivo) AS CountOfComplessivo, Sum(Nuovo.Importo) AS SumOfImporto
FROM Nuovo
WHERE Year([Nuovo.Data Spedizione])=2021
GROUP BY Nuovo.Complessivo;

But i notice Access is asking me a parameter when i run the query. If I introduce "1" in any case it works well (result are correct). Why do I get this behavior?

[Minty]

Normally that implies that the field name Importo is an incorrect spelling?

[gtsolid]

It's correct, i double checked

[CarlettoFed]

The following query

SELECT Nuovo.Complessivo, Count(Nuovo.Complessivo) AS CountOfComplessivo, Sum(Nuovo.Importo) AS SommaDiImporto
FROM Nuovo
WHERE Year([Data Spedizione])=2021
GROUP BY Nuovo.Complessivo;

returns the following result

starting from these data

[CJ_London]

check the properties of your query. I'm guessing your query used to reference 'query1' but now does not do so, but whilst it did you filtered and/or sorted on the Importo field. If this is the case, just remove from properties

[Minty]

Is Nuovo a table or another query?

[gtsolid]

If this is the case, just remove from properties

Where are the properties? do you mean right-click on the query and then "Object property"?

Is Nuovo a table or another query?

It's a table

[CJ_London]

Where are the properties?

in query design - click the property sheet option on the ribbon.

There are three different types of objects with properties - the tables/queries selected by the query, the columns created by the query and the query itself. Click on each to see the relevant properties for each type. To see the properties for the query itself, click anywhere in the query other than the selected tables/queries

[Minty]

After some sleep, a really simple solution would be to copy and paste the SQL (Which looks fine) into a new blank query.
If you still get a problem there is something else at play here.

[gtsolid]

After some sleep, a really simple solution would be to copy and paste the SQL (Which looks fine) into a new blank query.

that was the solution, thanks