filtering data from

Hi, all
I have one big table with 190 columns (!), there are user's data stored in
that table.
Now, there is a form on which i can select criteria (around 30) for
filtering users, not all criteria must be selected, so never know how many
and what criterions are chosen.
What would be the best way to implement the selection of users from my
table?
We have some ideas:
1) a.create one temporary table and insert there all users
b.for every criterion available from application form create one stored
procedure which would choose users not satisfying that criterion and remove
them from temp table, the procedure would be run only if criterion is
selected on the form
but this idea has some bad points: the table should not probably has an
index it would be slow to find records in such table and the problem with
defragmentation would appear here probably
2) create a procedure which would generate dinamically a where clause
depends on selected criteria passed to the procedure as parameters
but what happens if dinamically created statement exxceeds 8000 characters?

And which one would be faster?
Please advise, or maybe somebody would have some other ideas how this could
be done
mndr


.

Relevant Pages

  • RE: Easy Drop Down Box Question
    ... Then in your query use something like this as the criteria for the state ... Private Function BuildWhereCondition(strControl As String) As String ... Dim strWhere As String ... Case Else 'Multiple Selection ...
    (microsoft.public.access.forms)
  • Re: Filtering query by month and year
    ... then using those value as criteria for selection values of Expr1: ... "Jeff Boyce" wrote: ... Expr1: Month ...
    (microsoft.public.access.queries)
  • Search/Match/Find ANY part of string to ANY part of Cell Value
    ... Criteria is selected from the "Criteria" worksheet and then ... filter options, and column 8 contains advanced filter options. ... I have concatenated the filterselection into one string: ... lngTypeFound = InStr(1, strSearchRepType, strSearchType, ...
    (microsoft.public.excel.worksheet.functions)
  • ADO: Deleting records from duplicate recordset
    ... selection is complex enough that I want to loop through the entire table, ... records that fit my criteria in order to build up the final recordset the way I want it. ... On Error GoTo HandleErrors ... Set myRecordSet = Nothing ...
    (microsoft.public.access.modulesdaovba)
  • Re: How not to display similar records in a subform?
    ... Regards ... you're correct that the two criteria fields need not be shown. ... >> I understand that they are germane SELECTION criteria, ... >> Jeff Boyce ...
    (microsoft.public.access.forms)