I have a query where:
Field is Name
Table is Org
And I want to count the total of all sites named SITE1.
So I have:
Total is Count
Criteria is LIKE “*SITE1*”
I get an error.
What am I doing wrong?
My ultimate goal is to have this query count and give me the total of sites with other names. I need it to give me the total number of sites named SITE, SITE2, SITE3. Not the total of ALL sites, but the total of each named site.
Thanks.
Also, I do not know much of Access.