[AccessD] Counting "unknown" fields

Hi John,

Sounds like a totals query grouped by program name with a count on a non 
null field in the table. That will give you the results of one row per 
program name with a count of the records with that value.

Gary Kjos


>From: "John Clark" <John.Clark at niagaracounty.com>
>Reply-To: accessd at databaseadvisors.com
>To: <accessd at databaseadvisors.com>
>Subject: [AccessD] Counting "unknown" fields
>Date: Thu, 06 Mar 2003 11:01:41 -0500
>
>I haven't bothered y'all for a couple of weeks now, but I have painted
>myself into a corner, on the program that I am currently working on. I
>missed something in my early assessment of the old program that I am
>replacing, and I did not see something that was there. I have gone a
>different way with something, and now I am having difficulty
>accomplishing the same results.
>
>The old form looked like it had quite a bit of information on it, but
>when I actually looked close, there was quite a bit of waste. For
>instance, the change that I made was to convert 12 checkboxes into a
>single drop-down box. I'm really not sorry for this decision, because it
>served a couple of purposes, beyond simple aesthetics...the old
>"hardcoded" labels for the checkboxes are actually names that are no
>longer in use...it is a Social Services program, and they like to change
>their program names (i.e. Since I have been here, Public Assistance
>became Temporary Assistance, which is now known as Family
>Assistance...All it is, is Welfare with more PC titles...they should
>just call it BS, and everybody knows what that means). With the combo
>box, they can change the names, whenever they desire, and they can add
>and delete programs too...a couple of the current ones aren't used
>anymore.
>
>The problem is that, on one of their reports, they total out the check
>boxes for each section (i.e. 95 Denied HR cases in the Lockport
>office...the report is sectioned by Offices). Now that I have gone with
>the drop-down method, I cannot simply add up the check boxes. And, I
>cannot say count each x, because it can now change, and I don't know
>what "x" is...may not do so very much, but it can.
>
>Somehow I need to count each existing "x". I need to know that there
>are 5 x's, 6 y's, and 8 z's, but the next year I might also have a "q"
>that was added and I'll need to count that.
>
>Any ideas?
>
>
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com


_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus