I am building a report using an existing form image. A lot of the form contains checkboxes. I am trying to write an expression for a checkbox that looks for a particular word instead of equal to an exact phrase. For example, I have a list of procedures (test names) that contains the acronym in this case, "PCR" (SARS COV-2 PCR, RESPIRATORY PATHOGEN PCR PANEL, etc.). I googled this and found a couple different scenarios, but none of them work.
Suggested expressions:
=IIf([Procedure]="*PCR*",1,0)
=IIf([Procedure] Like "PCR",1,0)
What is the function that tells Access to look for a certain word within a string of words?
Thanks!
Kelly