create 1 query instead of many

[divanalle15]

hello!this is my first time in this forum
i hope you can help me with this...
i created a database wich has one table with many fields, what i need is a parameter query to sort the information on that table, the problem is that i want the user to decide wich fields he needs, and if he want to use parameters (criteria) or not on those fields he choose, i wanna now if this is posible with just one query instead of one for each combination of fields the user wants on his query. i hope i make myself clear if i dont just let me know
oh and the criteria is taken from comboboxes in a form, and the query is runned from a comand button on that form too.
thank you

 

[Banana]

In query builder, you can right-click on the criteria row and select "Build..." that will bring up Expression Builder dialog.

You can then navigate to Loaded Forms -> your form's name and select the control where the query should get its criteria from.

 

[divanalle15]

Re:

i've done that already, but what i need is for example to create a query with all the fields of the table, and with the expression builder bound them to the combo boxes in a form, one of them for each field, in this combo boxes the user will choose the criteria for the query for each field, but what i want is to be able to enter criteria or to choose for example a "No criteria" option, if the user doesnt want to sort that field.. i am sorry if i dont explain myself correctly but i dont speak english very well..
thanks

 

[Jon K]

See the sample database in this thread:-
http://www.access-programmers.co.uk/forums/showthread.php?t=103312
.

 

[divanalle15]

thank you very much!!! i love you!!!