Count Function - Help

[Irfan]

Hello,

I am having some problem with count function.

I have a report in which has grouping by a person wise and sub grouping in
invoied status e.g.. the output will be

Irfan Records (First Grouping by Person Wise)

Total Number of Records = 30 (I am using count("*") funtion to get this and
it works fine
Total Number of Records not invoied (this is my problem, basically I wanted
count function to count total number of records where invoice status = "not
invoied") but it's not working I am using =count([invoicestatus]="not
invoiced"] in the row sourse of the text box.

Next I wanted to display total number of recrds which are invoiced so I am
using count([invoicestatus]="Full invoiced"] in the row sourse of the text
box. but it is not displaying the correct number.

But it does not display the correct number. Please help with this.

Regards,

Irfan.

[Bruce M. Thompson]

> Total Number of Records = 30 (I am using count("*") funtion to get this and

it works fine
Total Number of Records not invoied (this is my problem, basically I wanted
count function to count total number of records where invoice status = "not
invoied") but it's not working I am using =count([invoicestatus]="not
invoiced"] in the row sourse of the text box.
You were close, but you want to "sum" that expression's resulting True/Value.
Try:

=Abs(Sum([invoicestatus]="not invoiced"))
Next I wanted to display total number of recrds which are invoiced so I am
using count([invoicestatus]="Full invoiced"] in the row sourse of the text
box. but it is not displaying the correct number.

Try the same as above, only using "Full invoiced".

--
Bruce M. Thompson
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)

NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<