search page in access

[tjewers]

Hi,

Do you think it is possible to create a form which will search a table which has over 18000 entries based on 13 criteria and 14 statistics.

This means that for each statistic there are 13 criteria. I am trying to decide if it is feasible to create this type of form.

Tracy

 

[rico_simo]

Hi,
it is feasible I think. First of all, 18,000 records are not a lot for Access. It is still efficient with more than 500,000 records. I think the "max" is something like 1,000,000.

Even if 13 criterias are going to slow down the application, I think that if you insert all the SQL in the VBA code that should work just fine.

Erik.

 

[Neal]

Have you tried filter by form? You can create a form with all the statistic controls and set the criteria for each. Then use filter by form and the results will be returned in the form. It is a lot easier than a bunch of coding. The help file on Filter by Form explains it better than I could.