Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Count number of negative records in filtered Access 2010 form

Posted on 2012-09-06
4
Medium Priority
?
758 Views
Last Modified: 2012-09-06
I have a form that includes negative numbers.  I am using the following equation as the control source of a text box to count the number of negative records:

=DCount([PEG_DAYS],"tblPurchaseReview","[PEG_DAYS]<0")

This does return the correct number of negative records.  However, when I filter the form, the number does not change.  Is there a way to count the number of negative records of the filter form?

Any ideas?
0
Comment
Question by:Scamquist
  • 2
  • 2
4 Comments
 
LVL 29

Accepted Solution

by:
IrogSinta earned 2000 total points
ID: 38374744
I believe it would work if you just add a textbox in your form footer or header with this expression:
=Sum(Iif([PEG_DAYS]<0, 1 0))
0
 
LVL 1

Author Comment

by:Scamquist
ID: 38374790
Worked great.  Thanks.
0
 
LVL 1

Author Closing Comment

by:Scamquist
ID: 38374791
I guess I tried to get too fancy.  Thank you for the assist.
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 38374880
You're quite welcome.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question