Choose order by

[gazsharpe101]

Hi everyone,

I am looking for some help with a particular problem. I have a report based on a query and at the moment it is ordered by a particular column.

What I want to be able to happen is that the user chooses what they want the query (and subsequently) the report to be ordered by before they run the report by means of a combo box or something like that.

Is this possible in anyway?

Thanks.
Gareth.

 

[ted.martin]

Only by replacing the query with an SQL statement in code and some form of textbox/combo box to set the OrderBy parameter from the calling form or sub.

 

[gazsharpe101]

I figured it would be something like this involving SQL. Do you have any idea how this is done as I'm not really sure.

Thank you for your reply.

 

[ted.martin]

zip and attach the db and I will take a look for you.

How do you want the OrderBy to be selected?