Question

[aroraaj]

I'm creating a data file. For one of the things I have calculate the number of suppliers.

This is what I have so far:

SELECT Data.Field8
FROM Data
GROUP BY Data.Field8
HAVING (((Data.Field8)<>""));

the data shows some numbers is there a way to exclude all the numbers? And does anyone know how it'll give me the # of suppliers? There are about 55 on the list.

 

[DCrake]

You need to add another column

Enter Cnt:1 in the Field Name section
Then select Sum in the grouping section. You should end up with

SELECT Data.Field8, Count(1) As Cnt
FROM Data
GROUP BY Data.Field8
HAVING (((Data.Field8)<>""));

 

[aroraaj]

This does work but it only counts the number for one supplier at a time.

I just need one number where it'll say:

Number of suppliers = 55.

 

[DCrake]

SELECT Count(1) AS cnt
FROM Data
WHERE (((Data.Field8)<>""));