If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting records based on a couple or many criteria items from a qu
I currently have a query set up consisting of several fields from several
tables. I'd like to solicit advise on the best way to set up search criteria. I've looked into building a dialog box containing combo boxes where the source of the combo boxes are individual queries. This is exactly the type of mechanism I'm looking for, but according to the documentation I've read I can't have more than two or three of the combo boxes on the dialog box as it creates a complex query. I have about eleven different fields I'd like to have the option to sort on - maybe sorting the records on many of them or just a few. Any advice on the best way of going about this is appreciated. |
Thread Tools | |
Display Modes | |
|
|