Pulling counts out of query results

[Ray]

I have a query that has one field Type which is set to Count
The query results are used in a report.
The report has the fields in the detail section as TYPE and CountOfType (1
line only in the detail section)
The report looks like this when displayed

AS 28
AV 17
OR 5

I need to be able to get the individual AS No (28) and add it to another
number elswhere in the report. How can I do this?

I have tried using a textbox with an if function (if
[type]="AS",CountOfType,0 but that did not work.

Any help appreciated.

Ray

 

[KARL DEWEY]

I think you will need to do it in the query.
But try adding a new field in your query output like this --
AS: IIF([TYPE] ="AS",1,0)
Change Group By to Sum
This will output your AS type in a field so you can use it in the report.

If that is of no help then post the SQL for your query.