Noob sorting queries question

[deresistance]

Noob alert :banghead:

Tried searching didnt find exactly what I want. I have a form that works all I want is a combo box that shows each tables field names. You pick the name and when you run your query it will SORT by that field name. Ideally I would like it to be that combo box with another combo box that list accending|desending etc. Anyone got an example of this? Not sure if I do that in the query or is this done in the report. My form submits it to a report currently. I am assuming its in the query.

Keeping this pretty general since I am trying to learn. I can post the db if required if its painful.

Thanks in advance

 

[jdraw]

That's a little too general.

There are tutorials at Martin Green's site that may help you
http://www.fontstuff.com/access/index.htm

He shows some forms with choices that you can select; and the code behind the scene; and examples

Good luck.

 

[deresistance]

I can tell thats going to be a helpfull site thanks jdraw.

As for my issue just to get it out there. Lets say I have a table with 4 objects A,B,C, D

I have a query using wildcards to search this table for specific data that works great. It prints it to a report. In that form when the user types in what they want to search I want a drop down that they can choose to SORT the report by A,B,C,D columns. So by defualt in the query column B is sorted descending order. I want the user to have the ability to choose how they sort it so the report looks cleaner.