A
Arvind Mahto
Can i pull out count of numbers more than 1000 out of the set of numbers?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
W
Wayne-I-M
Count(IIf([TableName]![FieldName]>1000,[TableName]![FieldName]))
F
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.
J
Jerry Whittle
SELECT Count([YourTable].[NumberField]) AS CountOfNumberField
FROM [YourTable]
WHERE [YourTable].[NumberField]>1000;
FROM [YourTable]
WHERE [YourTable].[NumberField]>1000;