Query med variable - hvad er der galt?

ORDER By [SomeField]

is the name of the field @Sort? if so you should try to NOt use special characters su cha s the danish ÆæÅåØø and spaces they just give problems!

The ORDER BY is one of the fields in the table for example

SELECT sag.Emne, sag.Dato
FROM sag ORDER BY sag.Dato;

Im not sure of what you mean. My table uses danish letters and its no problem so far.
The pronlem is that i can't assign a value to @Sort in my query, just as I do - without problems - with @Searching. If I ask it to sort/order by Dato, there's no problem. It's the variable aspect that don't work.

I am NOTsyaing that you shouldnt I am saying that it is BEST that you do not!

@Sort IS THIS A FIELD in your table? it MUST BE! It can NOT be a value? (variable)

SELECT * FROM YourTable ORDER BY AField

When you write [Searching] Then Access Can not find a field with this name so it expects a paramater this is OK in the LIKE clause.
This IS NOT allowed in the ORDER BY clause! It HAS to be one of the fields in your table an dit CAN NOT be entered through a paramater.
If you want to change the sort field then you have to dynamically create your query!

No, sort is a variable. When I run my query in Access, I'm asked to first input a value for @Searching and secondly one for @Sort. It's just that Access dont grab the value of @Sort which I write.
I'm going to use this query from an ASPX-page. And to avoid writing a query for each possible sort-order, I wanted to assign a value through a variable.
Now, if you say it's not possible, maybe I should avoid a query and instead create and execute a sql-string from within ASPX.

If you make a query using your example

SELECT sag.Emne, sag.Dato
FROM sag
WHERE ((sag.Emne) Like "*"+[@Searching]+"*")
ORDER BY [@Sort];

In query design view select the check Show box in the column where you can see [@sort] and then run the query. You will now see that whet ever you entered is shown in ALL records and that is why the sort has no effect !!!!

So the sort MUST BE A FIELD and NOT a parameter!

I get it. I wasn't aware the ORDER function was different.
Thank you Terry.

thnak you too :o)