Count is off when using =Count

[boywonder]

I have a header per customer and a detail area for the customer info. I'm trying to count the number of customers per the report, but when I use the Count function, it keep counting the detail. For instance if the customer had 2 records and there were only two customers, the count would be 3. When it should be 2. Here is the function I'm using:

=Count([FULL NAME])



The FULL NAME is in the Header section. I was using it in the Detail area. Please HELLLPPPPPP...

[khalid]

I am not fully understand what you what to count either the customers or the records of the customers, use the dcount() function:

Function:
DCount ( expression, domain, [criteria] )
Example:
DCount("UnitPrice", "Order Details", "OrderID = 10248")

[boywonder]

I just want to count the customers. In another report I added an unbound field in the query called Count "Count: IIf([check type] In ("P","G","O","H"),1,0)" to count check type, and it works OK, but still is off by one. It is showing 19 cx and after counting it is 20 customers. Is there an easy way to just count the customer???

[khalid]

I just want to count the customers.

user count aggregate function with groupby option in the query. Where all the customers will be grouped and then will be counted.

In another report I added an unbound field in the query called Count "Count: IIf([check type] In ("P","G","O","H"),1,0)" to count check type, and it works OK, but still is off by one. It is showing 19 cx and after counting it is 20 customers. Is there an easy way to just count the customer???

you are mixing the IIF() function with the count function, use IIF separately and then use the count function.

It's not clear without seeing your report and the fields,tables,query you use for the particular report. Count takes place in footer of the report, not in headers OR you should use the sub report inside the main report.