Hi Guys, new here, thanks for any help offered.
I'm self taught with Access so have limited knowledge and have hit an issue I can't find an answer to.
If I use Like "*" in the criteria for a ShortText field, I get the results I expect.
However if I use the following SQL I get no results
IIf(3=3,(([SimpleTable].[ShortText]) Like "*"),(([SimpleTable].[ShortText]) Like "*"))
could someone explain what's going wrong?
I'm self taught with Access so have limited knowledge and have hit an issue I can't find an answer to.
If I use Like "*" in the criteria for a ShortText field, I get the results I expect.
However if I use the following SQL I get no results
IIf(3=3,(([SimpleTable].[ShortText]) Like "*"),(([SimpleTable].[ShortText]) Like "*"))
could someone explain what's going wrong?