Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ricky Johnson   on Nov 13 In MS Office Category.

  
Question Answered By: Cheryl Murphy   on Nov 13

Not sure how my point and yours are the same. I'm saying never retrieve
large numbers of records at all, just retrieve counts. Your question was
regarding handling large numbers of records in Excel.

Why would you return 200,000 records at all? It won't help the user, who
certainly can't look at 200,000 records. If you want just the possible
sub-filter values for a given group of filters, use "select distinct" to
return just the sub-filter values.

Share: 

 

This Question has 19 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Populate Listbox Column Headings Or get search suggestion and latest updates.


Tagged: