I'm using Access 2003 to try and get some industry standards coverage data summarized. I have a nifty little query already setup that counts how many times each standard clause is covered by an audit. In that same query a field holds a variable that tells the user looking at it which standard it's from (AS9100, CMMI, PMBOK, etc.).
What I'd like the report to do is to count the number of non-zero records, but only for a given standard...
User Profile
Collapse
-
Conditional Counting in an Access Report
-
Never mind I found a work around. -
This sounds remarkably like something I'm trying to do. Currently I have 7 forms that were created to report essentially the same information about standards coverage. They each feed off the only two numbers from a query related to whichever standard X.
My goal is to combine those forms through a macro or module of some sort so that when the form (or report since that's what should probably have been created in the first place) is...Leave a comment:
No activity results to display
Show More
Leave a comment: