Counting the number of instances

[Artemis]

I am running a query where the result shows multiple instances of a word ('Aceeca') and I can see from the Record navigation bar that there are 62 instatances of the word.

My question is, How can I show within the query or even a report how many times that word appears?

Grateful for any help that can be offered.

 

[vbaInet]

Use the Duplicates Query and count based on that.

 

[Artemis]

OK I can now run a duplicate query which will give me the Number if each instance of the word 'Aceeca' however, the word can be in upper case, lower case or be followed by other text.

Is there a way of totalling the results?

Many thanks

 

[vbaInet]

Paste the duplicates query sql string here. Go to sql view.

 

[Brianwarnock]

If you just want the count then

SELECT Count(*) AS Expr1
FROM Tablename
WHERE (((Tablename.aceecafldname) Like "aceeca*"));

Brian

 

[Artemis]

OK, I have now got to the stage where the duplicates query shows the attached:

I would now like to add up the different totals on the right so they show a single total for all Aceeca's irrespective of what follows the word.

Grateful if the explaination could be as simple as posible

Thank for you help so far...

 

[Brianwarnock]

If you are trying to do it in the same query and show a new record, well you can't.

brian