Please help me find out why this formula isn’t working right.
I’m able to run my query, but it seems like the wildcards around
the “LAM” is not working. Is there another way I can put this together to get it to see the wildcards “*’”

IIf([Bill_Codes]="*LAM*","symanlam",IIf([MESSAGE_NOTES]="*LAM*","symanlam",([Site_ID])))


Thanks

Corey

Corey,
Instead of =, you should be using LIKE

HTH,

Kevin

dartcoach