Link to home
Start Free TrialLog in
Avatar of billinb
billinbFlag for United States of America

asked on

Old Query wizard dating young office manager

Anyone have an app that has tons of fields (160 flds, 3 tables, 30 fields in related table). I'm having difficulty finishing my application. Users are wanting to span several tables to query at run time.  I'm currently running/testing 20 query-by-forms each paired with a form that builds the filters. Start-up performance is bogging (I don't care about speed performance).  One Query wizard (qrywiz20) is user friendly but overworked (which the OM likes). Any thoughts, suggestions, recommendations?  Using Access 97.
Avatar of tcurtin
tcurtin

Try using subforms...
Avatar of billinb

ASKER

It would be difficult to query a subform.  I need to be able to filter on and print each of the 160 fields.  Consider an application that has 160 variables for each of 28 football teams. I need 16 forms with 10 fields each, as there is no correlation between quarterback efficiency and sacks per victory.
Quarterback efficiency is computed somewhere else - in another database. In order to peruse the various correlations, I need to be able to move thru all 160 fields in an efficient manor.
ASKER CERTIFIED SOLUTION
Avatar of tcurtin
tcurtin

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of billinb

ASKER

Thanks again TC