cassidybklyn
Programmer
Gentlemen and ladies please assist.
I populated an excel spreadsheet with data from access table, using "CopyFromRecordset" function.
The excel spreadsheet has been populated accurately. My problem is that in the xls spreadsheet, there are 5 fields and each field has multiple occurence of item: example, the name field has "John" appear five times and so does other fields.
Which vb code can I use to count each field items that has multiple entries?
Thanks a mil.
C.
I populated an excel spreadsheet with data from access table, using "CopyFromRecordset" function.
The excel spreadsheet has been populated accurately. My problem is that in the xls spreadsheet, there are 5 fields and each field has multiple occurence of item: example, the name field has "John" appear five times and so does other fields.
Which vb code can I use to count each field items that has multiple entries?
Thanks a mil.
C.