I have a list box containing a list of field names. The user would select/hi-light a number of these so they can find out quantities.

The file the fields are from is in csv format

ie: List box contains-
Title
Initial
Surname
Address1
Address2
Media Code
Ref Number

If the user selects 'Title' and 'Media Code' then click a command button. The app will run through the data counting how many of each variation it finds. A report will then be created.

Results for Title:
Mr - 3654
Mrs - 3554
Miss - 564
Ms - 884
Dr - 3

Results for Media Code:
A123 - 4533
B545 - 6003
Blank - 27

I was thinking on the lines of using an array to store the information but not sure. The user could select anything from 1 field upto and above 30. (Some files have over 100 fields to choose from.)

I do not want to import the data into a database. the records within the file range from a few hundred to 6-7 million.

Thanks for any help/ideas given.
PG