On 10/08/13 11:54 AM, Gene Wirchenko wrote:
I would like to see the number of uses of each WFC even if it is
zero. How do I do this last bit? I have a query, but it does not
report any of the unused WFCs.
The simplest way I can think of to do that is to have a separate 1-field
table of valid WFC's. Do your count(WFC) query, then match it to the
ValidWFC table and report the zeroes as well as your counts.
Assuming WFC's get validated, you may be able to piggy-back on whatever
the validation mechanism is using.
Dan Covill
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
