billinb
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.
Try using subforms...
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks again TC