count

[Arvind Mahto]

Can i pull out count of numbers more than 1000 out of the set of numbers?

 

[Wayne-I-M]

Count(IIf([TableName]![FieldName]>1000,[TableName]![FieldName]))

 

[fredg]

Can i pull out count of numbers more than 1000 out of the set of numbers?

Is this a Microsoft Access database program question?
You have asked a question but given us no context or example of what
you mean. You can see your computer, we cannot.
Please re-think your question, then re-write and re-post it, so that
someone who is not standing behind you can understand what it is you
are asking. Give us an example of the number set and what result you
would like to see.

 

[Jerry Whittle]

SELECT Count([YourTable].[NumberField]) AS CountOfNumberField
FROM [YourTable]
WHERE [YourTable].[NumberField]>1000;