cassidybklyn
Programmer
Gentlemen and Ladies,
Please I nee your assistance. I am coding with vb6. I populated an excel spreadsheet using data from access table. I used the "CopyFromRecordset" to populate the excel spreadsheet.
Now, my xls spreadsheet has 5 fields with records(items). Each item in the field has multiple occurence of the items. For example, the "Name" field contains "John" five times, the "account Number" field has "7788" eight times and so does other fields.
What code can I use to count each field items?
Your help will be appreciated.
Have a good day everyone.
C.
Please I nee your assistance. I am coding with vb6. I populated an excel spreadsheet using data from access table. I used the "CopyFromRecordset" to populate the excel spreadsheet.
Now, my xls spreadsheet has 5 fields with records(items). Each item in the field has multiple occurence of the items. For example, the "Name" field contains "John" five times, the "account Number" field has "7788" eight times and so does other fields.
What code can I use to count each field items?
Your help will be appreciated.
Have a good day everyone.
C.
