General discussion
September 13, 2002 at 06:36 AM
borginva

Counting in Criteria

by borginva . Updated 23 years, 12 months ago

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.

This discussion is locked

All Comments