Access 2000
I have a table that has entries, for example:
Microsoft
The Microsoft Corp
Building Microsoft
Microsoft 2
The Microsoft Site
5 sites, okay?
I want a query, or a report based off of this query, to count these sites and give mea total of 3. I DO NOT want the query to return:
Microsoft 1
The Microsoft Corp 1
Building Microsoft 1
Microsoft 2 1
The Microsoft Site 1
I want it, or the report, to give me this answer:
5
How can I do this query, or the query/report, to give me the total of entries?
I have tried doing a count on *microsoft* but it does not work.