Posted by Toby Inkster on 08/27/05 09:31

Ross wrote:

> Since i have >2000 records, if i open multiple columns for these
> categories, there may be more than >100 categories, and it will span
> widely in Excel spreadsheet

Ouch! The function I posted is really only meant for up to 200 or so rows
and maybe 10 columns. After that, it's inefficient and would overwhelm the
user with data.

Another part of the same site has to deal with a table of about 65,000
rows and about 15 columns. I think I've come up with a pretty good
solution for searching and sorting, but I don't have time to post it here
right now, as it would need a certain degree of tidying up to be suitable
for public consumption!

Feel free to e-mail me if you would like to discuss further.

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact

[Back to original message]