By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,680 Members | 1,508 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,680 IT Pros & Developers. It's quick & easy.

Count Function - Help

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
> 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.