Microsoft Office Questions? Ask a IT Expert for Support ASAP
HI there and welcome
Can I look at your file please? It will be easier.
Attach it by clicking the paperclip here and I can check it.
ok, go to http://ge.tt and attach it there and provide me the download link please
It was some time before you replied and I was not online, I will look at this now for you.
Ok, so the issue is the field you are querying is a lookup field its not actually storing the text which is why it does not work.
Convert the Program Field's Display Control under Lookup in the Tablet to Text Box, then re-enter the text correctly and you can then apply the like filter on the query and it works.
yes, but it is not already set to text box, I viewed this myself.
ok, I gave the specific steps to get there, it is a lookup, this is why you have the problem and I saw this on your copy.,
I have changed it and uploaded it here
You will now see the raw data for program in the query which will work on like statements now.
Let me know if you have difficulties.
the Root cause is you are using a lookup which you cannot do a like on as this is not the tables true data.
As I have been mentioning, it needs to be a text box which is what I did for you.
You created the problem by using a lookup field in a table which you should not do
I understand the issue, I am trying to tell you, and have shown you in my version, how to fix it.
so to reply to your statement "I need to the result of the filter to properly display the desired program name as it did with the criteria for Like "2*" and I am not understanding why it is not"
This is what I am explaining to you above.
yes, as I mentioned you need to retype it in to get the full value.
You need to type the values into the Program Field instead of just numbers.
Go to Table design, under Lookup for the program field (at the bottom)change it to Text Box, then re-enter the text correctly and you can then apply the like filter on the query and it works.
To redo the database you would have to make a new question
I am opting out on working with you on this as I have tried many times to explain why. I have even supplied you with the database with it solved, so I am out of ideas on how to explain it in another manner.
You do not need to do anything, you will be notified when someone takes over your case.