Hi everybody,

I have a report in Access, which is Yellow Pages. I want to make NY to be the first, then other states alphabetically. I put an expression in the sorting IIF(State="NY", "1" & [State], "2" & [State]), but it doesn't work. Is there a way to make it work without creating an extra field for sorting only?

Thanks in advance.