Access Database Dynamic Sort Query

Question

What is MSDN doing with the Access Database developer forum? Where did it go? Anyways, I have been trying to figure out where I failed in my SQL statement for my query. Trying to use an IFF() to change the sort order based on the value of a TempVar. My "Sort By" code goes as follows. No errors or anything popping up in the code, it just has no effect on the sorting.

ORDER BY IIf([TempVars]![tpvFavoriteList1]="TitleAsc","[qryArchive].[ObjectName]","[tblNavFavorite].[GUID]");

So as it is, I store the type of sort I want to perform in a tempvar and basically I was going to use the IFF() to read the tempvar variable. It isn't doing anything trouble is....

Answer 1

As Viorel says, you should delete the double quotes for the sort columns:

ORDER BY IIf([TempVars]![tpvFavoriteList1]="TitleAsc", [qryArchive].[ObjectName], [tblNavFavorite].[GUID]);

With the quotes you are telling Access to sort on constant strings, which is not very useful.

Next time you ask about Access try office-access for the tags. I'm not into Access myself, so I don't know what the tags are exactly, but I would expect it to be something like that.