COUNT without group by, possible

[sal21]

Code: Select all

    SQL = "SELECT PRE.TIT, PRE.N, PRE.CF, PRE.S, PRE.A, Count(PRE.CA) AS ConteggioDiCA" & _
          " From PRE" & _
          " WHERE Not (PRE.S) Is Null AND PRE.A>=#" & Format(minDate, "MM/DD/YYYY") & "# AND PRE.ID IN('CM','CN')"

have error?

But really to count i need to group y or not?

[HansV]

No, that won't work. If you don't group by TIT, N, CF, S and A, the count for every record would be 1.

What do you want to accomplish?