Totals from duplicates query

[Artemis]

I am trying to add the column 'CountOfDuplicates' to show a total in in a query or report.

Example:

Acceca 50

I need the report only to show the manufacurers name and the total for that manufacurer.

I have tried to do this in a report however it shows me every line. Can somone explain how this could be done in either the query or report?

Grateful for any help

 

[DCrake]

Have you got the manufacturer in a seperate column or it is part of the long string?

 

[Artemis]

A long sting. Example:

Acceca MEZ 1000 Handheld with USB cable and 128MB Compact flash.

I have managed to run a simple query which gives me 62 results. I would to show this in a report just showing:

Aceeca 62

I hope this is clear

Thanks for your help

 

[DCrake]

Your problem is defining which part of the string is the customer and which part is the part description. If you can get around that then it will be easy.

David

 

[Brianwarnock]

This is a follow on from another thread, and altho' my posts recieved no response I will try again, in your simple query you know the manucaturer so create a field to contain it thus your query becomes

SELECT Count(*) AS Expr1, "aceeca" AS Manufacturer
FROM Table1
WHERE (((Table1.aceecafld) Like "aceeca*"))
GROUP BY "aceeca";

BTW are you after the number of occurences or number of duplicates?

Brian

 

[Brianwarnock]

Take it you are not going to answer since you have been back on but not bothered.
Bye

Brian