SELECT COUNT distinct

[sal21]

SELECT CASSA.GIORNO, Count(CASSA.SCONTRINO) AS CONTASCONTRINO
FROM CASSA
WHERE CASSA.ANNULL IS NULL AND CASSA.ANNO='2021' AND CASSA.MESE='8'
GROUP BY CASSA.GIORNO

but i need to count distinct SCONTRINO

In my case the day 01/08/2021 have 11 SCONTRINO

 

[carp]

Have you tried:

SELECT CASSA.GIORNO, Count(DISTINCT CASSA.SCONTRINO) AS CONTASCONTRINO
FROM CASSA
WHERE CASSA.ANNULL IS NULL AND CASSA.ANNO='2021' AND CASSA.MESE='8'
GROUP BY CASSA.GIORNO

If that doesn't work, you might try

SELECT giorno, count(scontrino) 
  FROM (SELECT DISTINCT giorno, scontrino 
          FROM cassa
         WHERE ANNULL IS NULL AND ANNO='2021' AND MESE='8') v;

 

[sal21]

TKS CARP, have you tested?
i'm on Access

 

[carp]

No, I have not tested this. Since I didn't know what system you were on, it wouldn't have made much difference since I would have tested on Oracle.
But since it should be a simple copy/paste for you, it would be better if you tested it, no?

 

[carp]

Sal21 - have you tested?
This works on Oracle, but Access may have different results.

 

[sal21]

Carp, with a little modify, and work, tks.