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.
LVL 1
billinbAsked:
Who is Participating?
 
tcurtinConnect With a Mentor Commented:
I don' t know what the users want for data, but if you can drill down the 'typical' searches and store the querys you can build a form for each respective query. Use a table with a list of commonly selected items. Give the user a form with a listbox that reflects the list and a commandbutton that will bring up the appropriate form based on the selected value in the listbox. You could also create a form with a matching name for all of the listbox items.
I't just an idea...
0
 
tcurtinCommented:
Try using subforms...
0
 
billinbAuthor Commented:
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.
0
 
billinbAuthor Commented:
Thanks again TC
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.