I have the following scenario going in expression builder.
I want to sort a column for certain strings (say type 'A') but not for 'B'
The current formula I have is not working
Like (getstring([Forms]![Input]![txt1]) & "*") not like (getstring([Forms]![Input]![txt2]) & "*"
Any help is much appreciated!