This script will add a new column that will count the number of records based on a field that is selected by the user.
This script will allow you to select a file and a field in which you want to count the items. It will add a row and place the number of that particular entry.
If we use the ACCESS-Database.IMD that is used in the training we can see from the above that for the COUNTRY field we have Albania, Andorra and Angola. We run the script and will get this dialog in which we select the file and the country field.
Once we run the script a new field called COUNT will be added and you will have the following:
So from the above example we see that we have 146 records for Albania, 2 for Andorra and at least 6 for Angola (actually 16). This script will work on character, numeric, date and time fields.