Record Filter Buttons do not work

[shery1995]

Hi All

I m trying to to sort the records "Ascending & Descending" based on click of a button on listbox. However it does not work at all, can someone look at attached file and suggest a solution. Please note that "ClientID field" in tblClient is autonumber I am not sure whether that is causing a problem?

Many thanks

 

[theDBguy]

Hi. I think the problem is you're missing a space before the ORDER BY clause in your SQL statement.

 

[pbaldy]

This should show you the problem:

Debugging