how can i know count of any value in a field

[alimrb]

how can i know count of any value entered in a field

[ESpringer]

Alimrb,

There are a couple things you might mean by this:

(1) You want to know how many records have a value (any value at all) in a certain field. To do this, make a field defined as SUMMARY type, and specify in the options that you want a COUNT.

(2) You want to total all of the values entered into a certain field. To do this, make a field defined as SUMMARY, and specify that you want a TOTAL for the field in question.

(3) You want to count how many times a specified value (say, 8 or "chocolate") occurs in a field. To do this, make a number or text field with the GLOBAL storage option on to hold the particular value whose number of occurrences you want to hold, and also make a "flag" calc field to show a 1 iff the value is identical to your global field. Then, you can create a SUMMARY field to total the values in your flag calc field.

If you do this last kind of count frequently, you might think about setting up an additional table with the most common values listed, and set up a relation that allows an instant confirmation of how many records in the main table include that value for that field...

Let us know if this misses your needs or needs further spelling-out.

[alimrb]

i means (3). but i dont know what did user enter. i want to know count of any value that user entered.

[alimrb]

i means (3). but i dont know what did user enter. i want to know count of any value that user entered not a specific value.

[-Queue-]

If you mean a count of the value entered in the current record, then you could create a self-relationship from the field to itself, then create a calc field equal to Count( relationship::serial ) and put this field on the layout.

[alimrb]

thanks. how if i want to use these values in a report automatically.

[axishift]

dide you succeed sir?