I'd say.. split your database in 2 tables:

1 custID, custName etc
2 custID, noteDate, NoteDesc etc

retrieve the cust then lookup their notes.

i realize that any redesign is a chore..
but with 20.000 records I assume /presume :)
it's outgrown the original idea..



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


": VB :" wrote:


I have realised that within the spreadsheet of 20,000 records, there
are repeat rows - basically, the spreadsheet lists customer
information and also, notes. Rows of customers can be identical
except for the notes field which is always different.