468,241 Members | 1,648 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,241 developers. It's quick & easy.

Count Function - Help

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.
Nov 12 '05 #1
1 6187
> 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.<<
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Kuups | last post: by
3 posts views Thread by auron | last post: by
2 posts views Thread by DrewKull | last post: by
22 posts views Thread by MP | last post: by
3 posts views Thread by waynejr25 | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.