General discussion
September 22, 2002 at 05:33 AM
borginva

TotalFigure

by borginva . Updated 23 years, 12 months ago

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.

This discussion is locked

All Comments