Count

[lmossolle]

I am trying to get a Count [KT Number] where [KT Value] is less than 100000 i
am trying to use the below listed but I am getting errors, could some one
please assist?


BELOWSAT#: Count([KT Number] And [KT Value]<100000)

 

[lmossolle]

I am trying to get a Count [KT Number] where [KT Value] is less than 100000
and if [Effective FY QTR] = 1

i am trying to use the below listed but I am getting errors, could some one
please assist?

 

[John W. Vinson]

I am trying to get a Count [KT Number] where [KT Value] is less than 100000 i
am trying to use the below listed but I am getting errors, could some one
please assist?


BELOWSAT#: Count([KT Number] And [KT Value]<100000)

Where are you putting this???

The criteria and the count are separate operations. I'd suggest putting this
in the SQL view of a query:

SELECT Count(*) FROM yourtablename WHERE [KT Value] < 100000