In the Report Footer I had this script in my Access 2010. I am now converting the entire database to SQL with Access as the front-end. In the Control Source in the Report the conversion added the "A" Alike in it. I have no idea how to convert it to work with SQL and pull the word Consent from the Consents column.
Any idea? Thanks!
=Count(IIf([Consents] ALike "*Consent*",1))