How To (1 Viewer)

[icedearth]

Hi!

In here you see the query and the result. In the result i need to group by sucursal and count by numero_sucursal. to see how many loan_num are by sucursal. and the rest i want it to stay as it is.

 

[Guus2005]

My russian is not what is used to be. What is sucursal?

If you want to do a group by, klik the sigma button at the top of the Access window.
Loose the numero_sucursal field and put "1" instead.

HTH