Search results

GOT IT! It was an issue of parenthesis. =(DCount("*","OKC_MCC","[VERIFIED] Is Not Null"))/((DCount("*","OKC_MCC","[VERIFIED] Is Null"))+(DCount("*","OKC_MCC","[VERIFIED] Is Not Null"))) cant repay you in access skills, but if any autocad issues ever come your way, I'm your man

1st expression: =DCount("*","OKC_MCC","[VERIFIED] Is Not Null") 2nd expression: =DCount("*","OKC_MCC","[VERIFIED] Is Null") i think i am getting the syntax wrong, are not using the parenthesis correctly, i would need to "add" the two results, then divide that "number" by the first "result"...

once i populated one field, neither count would be zero, but i have to produce the counts, in the same way, then add the math to the expression? giving it a shot....

THANK YOU SIR!!! YOU ARE A ROCK STAR!! used the string to report both, seperate text boxes. could i make a third to report a number of the first one divided by the second?

I HAVE THE SAME NEED! except mine is a date field, so I just need a count on populated vs null entries. can also be any date greater than 01/01/2012 for populated, if it counts null entries too. have a text box waiting for the correct expression... i can post file or more of explanation...

I can submit or post file if that helps?

I know this is an old post, but I'm needing to do something similiar, and I'm not an access guy at all. I have a date field, used to reresent a verification process of procedures in our database. in one report, I have it displayed as a column, where null entries print in red background and...